View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Detect if current select is a row

Use Selection.Address to check

If row 17 is selected this will return $17:$17
--
If this post helps click Yes
---------------
Jacob Skaria


"Billy B" wrote:

Is it possible to test to see if the current selection is a row? I have a
command button that is designed to delete the selected row but but I need to
test to see if it is selected before running the rest of the macro.

Thank you.