how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel?

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

how do i get the name of a newly added sheet that i add with Sheets.Add in a
vba macro in excel?
 
Hi Daniel,
See http://www.mvps.org/dmcritchie/excel/sheets.htm

variable = ActiveSheet.Name
'Rename current Sheet
ActiveSheet.Name = "Renamed14a"
ActiveSheet.Name = "D" & Format(Date, "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyy_mmdd_hhmm")Also see http://www.mvps.org/dmcritchie/excel/pathname.htmfor
worksheet solution(s)Since you are familiar with macros you might want to thethe microsoft.public.excel.programming newsgroup--HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm "Daniel"
 
Back
Top