VBA If Entire Row selected in Selection Change Event

[decadence]

Hi, Is it possible to check if the Entire Row of Row 1 is Selected in the Selection Change Event? Can someone help please

 

[Fluff]

How about

 If Target.Count = Columns.Count And Target.Row = 1 Then MsgBox "all"

 

[decadence]

Thank you Fluff, This is perfect

 

[Fluff]

You're welcome & thanks for the feedback

 

[Peter_SSs]

Bit late but just stumbled across this thread so thought I would post my suggestion anyway since it only requires a single check.

If Target.Address = "$1:$1" Then MsgBox "All of row 1 selected"

 

[Peter_SSs]

Actually, on further consideration, I would highly recommend changing codes for this task as, without further checks/changes, Fluffs code could ..

a) Result in a message of "all" if you select, say, the range E1:AJ512 or J1:J16384 or any other range that starts in row 1 and contains 16,384 cells.
b) Cause a vba Overflow error if you select a very large number of cells (say selecting the whole sheet to set a new font)

 

[Fluff]

Good points Peter.
Also if you select more than one row, you wont get the message box.

 

[Peter_SSs]

Also if you select more than one row, you wont get the message box.

That is the same with my code but I was assuming that was the desired outcome. Hopefully we will get some clarification from the OP in due course.