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