You are here: Home » Macro Library » Renaming sheets
How do i make i = a ? I need it to go a,b,c…. instead of 1,2,3
You will need to use the Asc() function to convert a, b, or c to the ASCII code, then increment, then convert it back to a character using Chr().
When I copied and run the code I got error message Type Mismatch on below mention line line Set swDraw = swModel
Probably because you aren’t running the macro with a drawing open.
You must be logged in to post a comment.
How do i make i = a ? I need it to go a,b,c…. instead of 1,2,3
You will need to use the Asc() function to convert a, b, or c to the ASCII code, then increment, then convert it back to a character using Chr().
When I copied and run the code I got error message Type Mismatch on below mention line line
Set swDraw = swModel
Probably because you aren’t running the macro with a drawing open.