Posted to microsoft.public.excel.programming

Mike Fogleman Mike Fogleman is offline

external usenet poster

Posts: 1,092

Syntax using variable in cell Formula

I want to use a variable in a cell formula like this:
Dim myrng

myrng = Worksheets("Synopsis").Range("A" & Counter + 2)
Range("D1:D" & RowCount - 1).Formula =
"=IF(AND(Totals!$F$1-Data!B1<7,A1=A2,myrng),1,0)"

Because of the " " around the formula, the value of myrng does not appear,
only the word.

TIA, Mike

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
SaveAs syntax when using a variable	Keith	Excel Programming	3	November 4th 03 05:48 PM
Syntax for variable search	Tom Ogilvy	Excel Programming	3	August 6th 03 06:16 PM
Syntax for variable search	brym	Excel Programming	0	August 6th 03 05:41 PM
Syntax for variable search	brym	Excel Programming	2	August 6th 03 05:32 PM
Syntax for variable search	Don Guillett[_4_]	Excel Programming	0	August 6th 03 04:35 PM

All times are GMT +1. The time now is 07:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us