View Single Post
  #1  
Old June 4th, 2010, 07:58 AM posted to microsoft.public.excel.misc
swiftcode
external usenet poster
 
Posts: 8
Default automatic sheet selection

Hi all,

I need some help on the following. Assuming on sheet 1 in a workbook, in
column A2 to A30, i have the sheet names listed in each cell, how am i able
to write a macro when i selection the cell directly next to it eg B2, to
automatically jump to and select sheet 2 in my workbook.

Thank you in advance for any help rendered.

Rgds
Ray