Using VBA code for renaming the sheet

Help Studio
, ,
1

I am using VBA script for renaming the sheet after enable all the macros in
Excel Spreadsheet getting below error:

image
image1115Ă—211 13.9 KB

2

can you upload your sequence and vba file here?

3

PFB

image
image1137Ă—499 23.4 KB

Code for VBA
image

4

change ACCT-ID to ACCTID , you can’t have a “-” in argument name

like this

Sub ChangeSheetName(Sheet2 As String, ACCTID As String)
Sheets(Sheet2).Name = ACCTID
End Sub
5

Thanks you very much for the help…

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.