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.

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

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.