(for Excel 2003)
If a section of a worksheet has been autofiltered, macro commands involving
ranges of several rows might give unexpected results. Sometimes only the
visible rows are affected, even if all the row numbers (visible and hidden)
were selected in the macro. I need a way to predictably select and
manipulate all rows regardless of what is being autofiltered.

I understand Excel's approach, that oftentimes it makes sense to only deal
with the visible rows and filter out the hidden ones. However, in many
cases, this assumption seems flawed. I don't know what the user has chosen
to autofilter; my macro needs to run updates regardless of what he is
currently viewing. I would hate to check if every row is hidden for every
bit of code I've written....