Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get current cell value and place formula based on it in another column
Hi,
I'm trying to get a macro that will allow me to get information from a separate worksheet based on the text in the currently select cell, and place it 5 columns to the right. I got the vlookup working fine if not in the macro, but when i execute it It says "Method 'FormulaR1C1' of object 'range' failed". Help is greatly appreciated. Thanks Francisco Roque Sub GetPriceandCount() ' ' GetPriceandCount Macro ' Macro recorded 09/10/2006 by Francisco Roque ' ' Keyboard Shortcut: Option+Cmd+p ' Dim itemName As String itemName = ActiveCell.Value ActiveCell.Offset(0, 5).Select ActiveCell.FormulaR1C1 = "=VLOOKUP(armourName; Database!$A$1:$P$3869;13;FALSE)/100" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Static current date based on when data in another column was enter | Excel Worksheet Functions | |||
Run a macro in active cell only. Want to place current date/time. | Excel Worksheet Functions | |||
Place number into Cell Based on Match | Excel Discussion (Misc queries) | |||
Can I get current #row or #column in cell formula? | Excel Discussion (Misc queries) | |||
How to populate column with formula based on value in cell | Excel Programming |