MrExcel.com - Your One Stop for Excel Tips & Solutions

selection test

Posted by jgoulart@jps.net on January 31, 2002 8:18 PM

I can't figure out how to test and see if a cell is selected. Is there a command that I can test this for in VBA. I am trying to run a macro on all rows that there is a selection in.

Thanks,
John

Posted by Derek on January 31, 2002 9:20 PM

try using Selection.EntireRow.Select (NT)