Is there some simple way in VBA to tell if the user has selected an entire
column?

TIA

josh

Hi Josh

MsgBox Selection.Rows.Count = ActiveSheet.Rows.Count

returns true if an entirecolumn is selected

--
XL2002
Regards

William



"Josh Sale" <jsale@tril dot cod wrote in message
...
| Is there some simple way in VBA to tell if the user has selected an entire
| column?
|
| TIA
|
| josh
|
|

Hi,

Sub TEST()

If TypeName(Selection) = "Range" Then
If Selection.Areas.Count = 1 Then
If Selection.Areas(1).Rows.Count = Rows.Count Then
MsgBox "OK"
End If
End If
End If

End Sub


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

William, Soo,

Thanks for the insight! I like it.

Thanks,

josh