How to fix "Compile error" displays, "Variable not defined"

[Unicode]

Question for you. Sheet 1&2 name titles need to be changed with the following titles: Sheet1= PrePaidReport, Sheet2 = NewFormat, after I made the changes inthe VBA Script, Sheet titles change to capital letters, then I get, "Compile error" displays, "Variable not defined".

 

[mikerickson]

Are you trying to change the tab name of the worksheet whose codename is Sheet1?
If so the sytnax for that is

Sheet1.Name = "PrePaidReport"

 

[DanteAmor]

You can put your code

 

[Unicode]

Hi there, thank you for the message follow up, I believe all has been fixed and we can close this one. I added the following and all appears to work. However, I might need something additional for these sheets, I will follow up with you and all details. ADDED: "Dim sht As Worksheet"

Are you trying to change the tab name of the worksheet whose codename is Sheet1?
If so the sytnax for that is

Sheet1.Name = "PrePaidReport"