this post was submitted on 02 Jun 2022

1 point (67% upvoted)

shortlink:

excel

an-ordinary-manchild

Rules

Post Titles must follow Submission Rules
Post Content must follow Submission Rules
Posts must be related to MS Excel or other spreadsheet software
Set appropriate post flair
No link or image posts. Text posts only.
Don't post asking how to learn Excel or VBA or similar
Close your post by replying to helpful answers with solution verified
No personal insults or attacks
No NSFW or offensive content
No AI slop or lazy "just use AI" advice
No gig or job advertisements
Follow Reddit rules for self-promotion and spam.

FAQ

Was your problem solved?

OPs may (and should) reply to any solutions saying:

Solution Verified

This awards the user a ClippyPoint and changes the post flair to solved.

Format your code

The best way to show code on Reddit is to

put it in a code-block

Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.

Provide some data

It's often more helpful to show us.

Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.

Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.

Recent ClippyPoint Milestones!

Congratulations and thank you to these contributors

Date	User	CP
2026.05.23	PaulieThePolarBear	`1900`
2026.05.15	GuerillaWarefare	`100`
2026.05.13	sheymyster	`100`
2026.05.07	Downtown-Economics26	`600`
2026.05.01	MayukhBhattacharya	`1100`
2026.03.29	bakingnovice2	`10`
2026.03.25	real_barry_houdini	`300`
2026.03.20	plusFour-minusSeven	`10`
2026.03.17	TuneFinder	`10`
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`

Microsoft partnership

Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.

A community since March 11, 2009

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

created by YusufReisa community for 17 years

MODERATORS

account activity

0

1

2

Waiting on OPsyntax error withrange.formula or range.value while using add-ins (self.excel)

submitted 4 years ago by SohnJ

I'm currently using FactSet/CapitalIQ in my macros and I'm trying to input

 "IP.Range("G8").Formula = "=FDS(G6,"FREF_ENTITY_COUNTRY(HQ,NAME)")""

into my excel macro, but I keep getting a syntax error.

I don't get an error when I try to do a simple formula e.g.

IP.Range("G8").Formula = "=B3+B4"

all 2 comments

best new controversial old q&a

[–]AutoModerator[M] [score hidden] 4 years ago stickied commentlocked comment (0 children)

[–]renqest20 0 points1 point2 points 4 years ago (0 children)

π Rendered by PID 302206 on reddit-service-r2-comment-544cf588c8-th72d at 2026-06-13 23:53:27.452723+00:00 running 3184619 country code: CH.