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