Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

How to Insert Variables into Formula's

...or this one-liner:

Public Sub Tester001()
Sheets("Standard Analysis").Range("A6").FormulaR1C1 = _
"=('Unit 2 Week 2 Test Standards An'!R[2]C)"
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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
formula's	time conversion[_2_]	Excel Discussion (Misc queries)	3	February 7th 09 10:35 PM
Storing variables in a macro and using those variables to performcalculations.	[email protected]	Excel Programming	3	December 10th 07 04:13 PM
can excel automatically collect variables to redue a formula's si.	JeffV	Excel Discussion (Misc queries)	1	July 6th 07 10:42 PM
Insert dummy variables	Chris_t_2k5[_2_]	Excel Programming	2	February 26th 06 01:27 PM
Need Help w/Formula's	sunrosejenn	Excel Worksheet Functions	5	October 24th 05 07:33 PM

All times are GMT +1. The time now is 10:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us