Thread: using VBA to rename active sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kkknie[_235_] kkknie[_235_] is offline
external usenet poster
  
Posts: 1
Default using VBA to rename active sheet

If you are renaming the active sheet use:

ActiveSheet.Name = "Date (altered)"

If you are renaming the first sheet use:

Sheets(1).Name = "Date (altered)"

If you are renaming a sheet with a specific name use:

Sheets("Sheet1").Name = "Date (altered)"




--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26966

Reply With QuoteReply With Quote