Hello,
Have a question in regards to counting visible worksheets. I need several functions to be performed on several worksheets beginning with the 10th, and continuing onward to the total number of visible workbooks. I have the below line of code, but need it altered to count only visible sheets and perform functions based on that. I tried doing an if statement prior and storing it as a variable but it wouldn't work.
Please Login or Register to view this content.
Thank you!
You are referring to both worksheets and workbooks. Is that a typo and you just mean counting to the total numbet of worksheets in the Active workbook?
In which case why not just
If Sheets(i).Visible = True Then
'blah blah
End If
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Yes that's just a typo, my apologies. And I cant' do that because I need it to count all visible worksheets after i = 10. I just need that count function to only count the visible cells. I know this won't work, but Foris essentially what I'm looking to do.Please Login or Register to view this content.
try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks