View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Billy B Billy B is offline
external usenet poster
 
Posts: 54
Default Detect if current select is a row

Thank you for the help. What is really going on is the user may or may not
select the row and if the row is selected, do the procedure and if only a
cell is selected, select the row. The next reply did address that. Thanks
again.

"Jacob Skaria" wrote:

If you are looking to delete the row you can use

Rows(Selection.row).delete
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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.