I'm having trouble determining the UsedRange of the sheet in a macro. I seem to remember doing it with no trouble a while back in 97. Anybody have a foolproof way of automatically determining the UsedRange?
Along that same vein...Once I have the UsedRange, what's the best way to get the numbers for the first/last row and first/last column? Knowing the exact range to process would certainly speed up processing times.
Thanks for the help.
Drew
Along that same vein...Once I have the UsedRange, what's the best way to get the numbers for the first/last row and first/last column? Knowing the exact range to process would certainly speed up processing times.
Thanks for the help.
Drew