Macro to change a worksheet name

[Virginia]

Hi,
I'm very new to VBA and am trying to write a macro that will copy an
existing worksheet and then rename it.
I've got the copy bit OK, but is there anything I can do to change it's
name.
Thanks
Virginia

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Hi Virginia

Try

Sheets(1).Copy Before:=Sheets(4)
ActiveSheet.Name = "New sheet"

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Virginia]

Thanks Dave
You're a Gem!
Virginia

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****