Posted to microsoft.public.excel.programming

Sune Fibaek Sune Fibaek is offline

external usenet poster

Posts: 38

Vaiable in range().formula

Hi

This is probably quite trivial, but how do I do somthing like this:

ActiveSheet.Range("A1").Formula "=VLOOKUP(" & strLookValue(intLookNum) &
",Setup!A1:A15,2,FALSE)"

I am trying to add a variable from an array to the VLOOKUP formula.

/Sune

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
use vaiable for all sheets	R..VENKATARAMAN	Excel Programming	5	October 4th 06 04:50 AM
vaiable colours for selection in chart	NoelH	Charts and Charting in Excel	4	October 27th 05 04:43 AM
Assign vaiable to a cell - gold	gold gold via OfficeKB.com	Excel Worksheet Functions	1	June 4th 05 04:31 AM
Clearing a date vaiable	PSKelligan	Excel Programming	0	April 27th 05 11:39 PM
Clearing a date vaiable	Alok	Excel Programming	1	April 27th 05 10:21 PM

All times are GMT +1. The time now is 05:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us