Changing Worksheet Names in Excel

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 391,594 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,669 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 3885 | Replies: 0

•

Join Date: Dec 2005

Posts: 1

Reputation: policy10 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

policy10

Offline

Newbie Poster

Changing Worksheet Names in Excel

Dec 19th, 2005

I have a macro that copy-paste from a sheet to another... in that file i need to change the name of the sheets all the time, but the macro code does not understand that and gives me error...

Sub Copiar3()
'
' Copiar3 Macro
' Macro gravada em 02-12-2005 por Henrique Pinho
'

'

Range("B8

9").Select
Selection.Copy
Sheets("Acção2").Select
ActiveWindow.SmallScroll ToRight:=-3
Range("D1").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll ToRight:=3
Range("E7").Select
End Function

this is name of the sheet! but when i change it, it keeps the same here! any solutions??

ps: the strange names are in portuguese!