ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Row Selection or Column Selection or other ? (https://www.excelbanter.com/excel-programming/332455-row-selection-column-selection-other.html)

wesbird

Row Selection or Column Selection or other ?
 
Hi
How are you?
right now I work on a event function in Worksheet_SelectionChange. How do
I know the new selection is a row selection ?

Thank you very much
Wes

Bob Phillips[_7_]

Row Selection or Column Selection or other ?
 
One way

MsgBox Target.Columns.Count = Me.Columns.Count

--
HTH

Bob Phillips

"wesbird" wrote in message
...
Hi
How are you?
right now I work on a event function in Worksheet_SelectionChange. How

do
I know the new selection is a row selection ?

Thank you very much
Wes





All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com