| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With VLOOKUP VBA Script Line
Hi Everyone
I have this code in Excel 2007 VBA It has a value of say 1500 in lnLastNonBlankRowNumberDeliveries ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Deliveries!$B$8:$AI$" & lnLastNonBlankRowNumberDeliveries & ",32,FALSE)" I'm getting an "Application-defined or object-defined" error. Can someone help me out. Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help With VLOOKUP VBA Script Line
RowNum substituted for your paragraph...
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Deliveries!R8C2:R" & RowNum & "C35,32,FALSE)" -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Extras for Excel add-in: convenience built-in) "Andy" wrote in message ... Hi Everyone I have this code in Excel 2007 VBA It has a value of say 1500 in lnLastNonBlankRowNumberDeliveries ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Deliveries!$B$8:$AI$" & lnLastNonBlankRowNumberDeliveries & ",32,FALSE)" I'm getting an "Application-defined or object-defined" error. Can someone help me out. Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB script line graph | Excel Programming | |||
| Passing Data to a Line in a VBA Script | Excel Programming | |||
| Need Comand line or VB Script | Excel Programming | |||
| command line Excel Script | Excel Discussion (Misc queries) | |||
| which line mercy script | Excel Discussion (Misc queries) | |||
Linear Mode
