Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to select current sheet tab | Excel Programming | |||
Select Current Row | Excel Programming | |||
How do I detect and commit the current cell edition? | Excel Programming | |||
how to select current range | Excel Programming | |||
How to detect current active sheet number | Excel Programming |