how would activate the previous sheet in macro

Giganews Newsgroups
Subject: how would activate the previous sheet in macro
Posted by:  Vicky
Date: Fri, 26 May 2006

Hi,
Every day I insert the new sheet in the source file  I have various sheets
in a file with different sheet names. I have recorded a macro in excel file
to pull the data from Previous sheet whenever I run the macro, the sheet
names are always different. Is it possible to select the latest or previous
sheet.

--
Vikram Dhemare

Replies