first check that only one row is selected:

MsgBox (Selection.Rows.Count)

and then check that the entire row is selected:

MsgBox (Selection.Count)

for a complete single row, the first should be 1 and the second should be 256
--
Gary's Student


"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