| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas change when macro adds new column
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? |
| 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
