is there a way to determine the range of populated cells in a spreadsheet?
J John Wilson Jan 20, 2004 #2 steve, Populated cells??? Try ActiveSheet.UsedRange.Select Possibly you just want a contiguous range?? Activecell.currentregion.select You can look up both of these in the VBA Help. John
steve, Populated cells??? Try ActiveSheet.UsedRange.Select Possibly you just want a contiguous range?? Activecell.currentregion.select You can look up both of these in the VBA Help. John
