Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I check the number of rows selected
Hi,
My sheet has about 30 rows. I want the user to select only one row and that row gets copied to a new sheet. The Code to let the user select the row is Set rng = Application.InputBox(prompt:="Select Column to Work on", Type:=8) rng.Select How do I make sure the sure only one row is selected? If more than one row is selected I need to display an error message. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA how to check if entire row is selected? | Excel Discussion (Misc queries) | |||
How to fix a number of rows below the selected cells? | Excel Discussion (Misc queries) | |||
Copy a selected number of rows | Excel Discussion (Misc queries) | |||
Finding the minimum in a selected number of rows of the same colum | Excel Worksheet Functions | |||
check for selected columns in a macro | Excel Programming |