A while back I got some great help here with how to work with a selected range. Pretty straightforward.
I'd like to do the same thing now, except exclude any hidden rows and columns. I also want to make sure that I can still loop over that range using simple for loops.Dim r As Range Set r = Application.Selection
I'm guessing that each cell may also have a hidden/visible property that I could examine (haven't looked into it yet), but if I could just get a range that excludes those cells it would be much easier.For i = 1 To r.Rows.Count For j = 1 To r.Columns.Count mytext = r.Cells(i, j).Text Next Next
Bookmarks