Is it possible to have a macro run with only the data showing on the screen? I am trying to make a macro run with data that I manually filter before running it, but it picks up the data that I have filtered out.
Is it possible to have a macro run with only the data showing on the screen? I am trying to make a macro run with data that I manually filter before running it, but it picks up the data that I have filtered out.
Yes, something like:
![]()
Dim cell As Range ' For Each cell In Intersect(Columns(1), Range("A1:J20").SpecialCells(xlCellTypeVisible)) Debug.Print cell.Address Next 'cell
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Perfect. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks