Excel Used ghost

Excel Used ghost

19 October 2014

The Worksheet Object has a UsedRange property. Normally, we should be able to use this property so that we can quickly identify the entire UsedRange on the Worksheet without having to jump through a lot of hoops.

However, a false positive occurs when we test for data and Excel tells us that there is data when in fact there is not. This article develops a VBA function for finding the true used range of a Worksheet.