Is there some simple way in VBA to tell if the user has selected an entire column? TIA josh
J Josh Sale Aug 10, 2004 #1 Is there some simple way in VBA to tell if the user has selected an entire column? TIA josh
W William Aug 10, 2004 #2 Hi Josh MsgBox Selection.Rows.Count = ActiveSheet.Rows.Count returns true if an entirecolumn is selected -- XL2002 Regards William [email protected] | 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 [email protected] | Is there some simple way in VBA to tell if the user has selected an entire | column? | | TIA | | josh | |
S Soo Cheon Jheong Aug 10, 2004 #3 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 _ _ ^¢¯^ --
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 _ _ ^¢¯^ --
