Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Vlookup formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Vlookup formula
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Vlookup formula
Hi Fred,
ActiveCell.Formula = "=vlookup(" & c & rw & ",ShopNames!A3:B100,2)" -- Kind regards, Niek Otten Microsoft MVP - Excel "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Vlookup formula
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Vlookup formula
Maybe...
ActiveCell.Formula = "=vlookup(C" & rw & ",ShopNames!A3:B100,2)" Fred wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup formula error | Excel Worksheet Functions | |||
N/A Error with VLOOKUP Formula - Excel 2007 | Excel Worksheet Functions | |||
#Ref error when using vlookup formula | Excel Worksheet Functions | |||
VLOOKUP Formula causing an error | Excel Discussion (Misc queries) | |||
Error in vlookup formula | Excel Worksheet Functions |