macro help

  • Thread starter Thread starter michael
  • Start date Start date
M

michael

I would like to create a macro that will increase
numerically the worksheet number.
 
Sub AddOne()
On Error Resume Next
ActiveSheet.Name = CStr(Val(ActiveSheet.Name) + 1)
End Sub

HTH. best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Excel Monthly Spread sheet. 12
Close all without saving and exit without prompts 8
Hide columns based on row values 2
Worksheet Names using Macros 5
Macro to get rid of #DIV/0! 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro help 4

Back
Top