I am using an array to loop through specific sheets.
I want to add the name of the sheet to range("I2") - I tried .range("I2").value=Worksheets.namePlease Login or Register to view this content.
wks.name does not work
I am using an array to loop through specific sheets.
I want to add the name of the sheet to range("I2") - I tried .range("I2").value=Worksheets.namePlease Login or Register to view this content.
wks.name does not work
If this solves your issue, Mark thread as Solved & Add Reputation.
Thanks!
How aboutPlease Login or Register to view this content.
It gets Object required error
Do all the sheets exist in your workbook?
The following works for me in a new workbook with 4 worksheets.
Please Login or Register to view this content.
Good point.
Is there really any good reason for Option Explicit not to be the VBA default?
None that I can think of.Is there really any good reason for Option Explicit not to be the VBA default?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks