Posted to microsoft.public.excel.programming

external usenet poster

Posts: 542

help in syntax

I am trying to write the following formula into cell.

.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(COUNTIF("&rRange & "," & sCell&")1,TRUE,FALSE)"

where rRange and sCell are range variables.
I got syntax error.
Would anyone help?

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA syntax	dhstein	Excel Discussion (Misc queries)	3	March 13th 09 12:53 PM
IRR Syntax	Bruce	Excel Worksheet Functions	1	July 13th 07 09:02 PM
If then syntax	RL	Excel Worksheet Functions	3	June 22nd 05 05:30 AM
Need some syntax help, please	MARTY	Excel Programming	3	July 4th 04 04:36 PM
syntax	Don[_13_]	Excel Programming	2	November 16th 03 03:30 AM

All times are GMT +1. The time now is 08:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us