View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lolly
 
Posts: n/a
Default Jumping colums in Excel 2000

In a spreadsheet using about 20 columns, after entering a letter in Column C
or just pressing Enter, I need to jump from Column C to Column E. It has been
brought to my attention that I need to create a Macro for this function, but
unfortunately I cannot find one that works. I think the Macro may relate to
SelectionChange.
There is a vlookup equation in Column D and that works brilliantly.

Help would be greatly appreciated.