Test if entire row is selected

[Jan Kronsell]

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

 

[Dave Peterson]

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]

Thak you. That did it.

Jan

if selection.address = selection.entirerow.address
or
if selection.address = activecell.entirerow.address
(if you wanted to check if it was a single row)