Thread: How do I renumber a worksheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default How do I renumber a worksheet
http://www.cpearson.com/excel/codemods.htm

look toward the bottom of the page. The argument to vbcomponents is the
codename.

--
Regards,
Tom Ogilvy


"GaryMay" wrote:

Thanks, that works, but I have a need to be able to do this through VB code.
Do you know how?

"Tom Ogilvy" wrote:

In the project explorer in the VBE, select the entry for the sheet.

make the properties window visible. Change the (name) property.

--
Regards,
Tom Ogilvy


"GaryMay" wrote:

How do I renumber (reindex) a sheet using VBA.

Example:
sheet20(name) to sheet1(name)
Reply With QuoteReply With Quote