How can I use VBA to get the names of all the worksheets (or alternatively a maximum of three) within the active workbook to be returned as a string? For context, I will then use the string in naming the workbook when it is saved. I have figured out how to create a savename for the file using input dialogs and so on, so it's only a case of getting VBA to return something like "[Worksheet 1 name] and [Worksheet 2 name]".
Thanks so much!
Option Explicit
Sub namesheets()
Dim wks as Worksheet, strName as String
For each wks in Worksheets
strName = strName & wks.Name
Next
End Sub
You can also google "Excel vba loop through worksheets in a workbook" or something to that effect and find the answer very easily.
Also, this question was asked in some form on this website. See link... Loop through subset of worksheets
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With