MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Select All Test in Excel?

Posted by AO on August 07, 2001 6:41 AM

I currently have a macro in Excel that executes either against a range that the user has selected or against the active sheet (dependant on what the user has selected). I would like to add another condition in the case that the user selects the entire worksheet so that it would only do the active sheet. How do I test to see that the user has selected all cells on the sheet?

Posted by mseyf on August 07, 2001 11:43 AM

you could try:

If Selection.Address = Cells.Address Then ...