Is column selected

  • Thread starter Thread starter Josh Sale
  • Start date Start date
J

Josh Sale

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

(e-mail address removed)

| 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
_ _
^¢¯^
--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat value in column A by number in column B in column C 10
checkbox in Excel form 4
column of a input box selected range 5
What is "my" cell? 4
Delete rows based on contents of Col A 0
How to copy only to cells where there is data 4
Exiting Design Mode 2
Set a column to "text" 2

Back
Top