UsedRange always giving me problems
Posted by Tim on January 17, 2002 5:23 AM
It seems to me that the UsedRange property of a worksheet sometimes returns different ranges based on conditions that I can not determine.
I especially have problems selecting Used Range and it will select rows 1-3 for example. I will clear all, delete contents, delete the rows, reinsert rows, anything...but it still thinks that those rows are used.
Again, this seems inconsistent, sometimes I don't have the problem. Any ideas or procodures that should be followed when using this property?