Posted to microsoft.public.excel.programming

Bri[_3_]

external usenet poster

Posts: 29

syntax when using a variable in a formula

Lets say the formula is to be pasted into cell A1. Try entering the formula
the way you have it, then use something like:

ActiveSheet.Range("A1").Replace "Sheet23", SheetName

cheers
Bri

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
syntax for variable	adamaagard	Excel Programming	2	January 20th 06 12:45 AM
Syntax to Set variable range	Mike Fogleman	Excel Programming	3	December 10th 05 09:11 PM
Syntax using variable in cell Formula	Mike Fogleman	Excel Programming	2	January 28th 04 12:47 AM
SaveAs syntax when using a variable	Keith	Excel Programming	3	November 4th 03 05:48 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 08:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us