About Us

Don Guillett

glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred" wrote in message
...
Thanks Don.
I had tried the quotes, but forgot about the second ampersand. Work great
now!
Fred

"Don Guillett" wrote:

try
ActiveCell.Formula = "=vlookup(C" & rw & ",ShopNames!A3:B100,2)"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred" wrote in message
...
Hi
I'm not sure where my error is in this code. In other formulas, this
works.

Dim RW As Integer
RW=1
ActiveCell.Formula = "=vlookup(C & rw,ShopNames!A3:B100,2)"

The "C" is referring to the C column and the "& rw" is referring to row
RW,
what ever the row # happens to be.

What am I missing?

Thanks
Fred

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup formula error	Samantha	Excel Worksheet Functions	2	April 10th 10 01:41 PM
N/A Error with VLOOKUP Formula - Excel 2007	David Scarfe	Excel Worksheet Functions	6	January 3rd 10 05:12 AM
#Ref error when using vlookup formula	neil	Excel Worksheet Functions	2	May 14th 07 08:35 PM
VLOOKUP Formula causing an error	japc90	Excel Discussion (Misc queries)	2	July 25th 06 11:36 PM
Error in vlookup formula	Minos	Excel Worksheet Functions	4	July 5th 06 05:29 AM