Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Worksheet range is wrong
- Thread starter qureshi
- Start date
8 but when I use the above command the selected range is like A1:BI567.It returns the range of cells that have ever been used, not what is used now. All it takes is an entry in cell BI567, and even if you delete it afterwards, the sheet has been used up to that reference. What about using CurrentRegion instead?
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question