if selection.address = activecell.entirerow.address then
'single row selected
else
'not a single row
end if


Jack Sons wrote:

Hi all,

How to code:

If rownumber 1 and rownumber < 43 And an entire row is selected Then ....

The first part is no problem, but I don't know what to do with "And an
entire row is selected "

Your help will be appreciated.

Jack Sons
The Netherlands

--

Dave Peterson