Member Avatar for policy10
policy10 0 Newbie Poster

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:P9").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! :)

  • 1 Contributor
  • 0 Replies
  • 77 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.