| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if entire row is selected
Hi NG
Is there any way to test in VBA if an entire row has been selected? I tried with something like If Selection.EntireRow = True but that didnt do the job :-) Jan -- For den, der kun kender en hammer, komme alle problemer hurtigt til at ligne søm. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Test if entire row is selected
if selection.address = selection.entirerow.address
or if selection.address = activecell.entirerow.address (if you wanted to check if it was a single row) Jan Kronsell wrote: Hi NG Is there any way to test in VBA if an entire row has been selected? I tried with something like If Selection.EntireRow = True but that didnt do the job :-) Jan -- For den, der kun kender en hammer, komme alle problemer hurtigt til at ligne søm. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Test if entire row is selected
Thak you. That did it.
Jan Dave Peterson wrote: if selection.address = selection.entirerow.address or if selection.address = activecell.entirerow.address (if you wanted to check if it was a single row) Jan Kronsell wrote: Hi NG Is there any way to test in VBA if an entire row has been selected? I tried with something like If Selection.EntireRow = True but that didnt do the job :-) Jan -- For den, der kun kender en hammer, komme alle problemer hurtigt til at ligne søm. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA how to check if entire row is selected? | Excel Discussion (Misc queries) | |||
| Simple Macro problem. How do I test the entire range | Excel Programming | |||
| Test if cells are selected | Excel Programming | |||
| delete entire row based on conditional test of column A | Excel Programming | |||
| Is there a test to see if an entire row or column is empty? | Excel Programming | |||
Hybrid Mode
