Thread: Formulas change when macro adds new column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandra Sandra is offline
external usenet poster
  
Posts: 39
Default 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?
Reply With QuoteReply With Quote