| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas change when macro adds new column
On Jan 24, 7:44*am, Sandra wrote:
*Spreadsheet has formulas that pick up values from data tab. *Macro inserts a new column B in the data tab. *When it does that, the formulas move from B:C to C:D. *The formula is in a vlookup. *How do I get the formula to stay as B:C. *I tried INDIRECT but it does not work in VLOOKUP. *Any ideas? INDIRECT works in VLOOKUP for me, eg... =VLOOKUP(A1,INDIRECT("C1:D6"),2,0) Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional change of column reference in formulas | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| Is there a macro which adds selected/highlighted cells? | Excel Worksheet Functions | |||
| Looping Macro That adds a blank row between different part #'s | Excel Discussion (Misc queries) | |||
Threaded Mode
