Thread: switch to another worksheet, then return to original sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tonso Tonso is offline
external usenet poster
  
Posts: 90
Default switch to another worksheet, then return to original sheet
On Thursday, September 6, 2012 2:13:26 PM UTC-4, Tonso wrote:
I have recorded a macro that daily copies a row of data on the current worksheet, then goes to a sheet named "data" and appends this data to a list. I want to have the macro return to the current sheet. However, I add a sheet every day and so the name of the current sheet is different every day. How can i accomplish this? Thanks, Tonso

Claus,
Thank you so very much!

Tonso
Reply With QuoteReply With Quote