ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selection Column (https://www.excelbanter.com/excel-programming/371575-selection-column.html)

Abdul[_2_]

Selection Column
 
Hi All,

How i could say selection column 1 or 2 etc?

For eg if I select range B2 thru Range E10 in the selection column1
will be B and column 2 will be C

How i can reference them.. say for eg i want cente align column 2nd
column of the selected area?

Thanks


Gary''s Student

Selection Column
 
Sub gsnu()
Columns("C:C").Select
Columns(3).Select
End Sub

are alternate ways of selecting column C
--
Gary's Student


"Abdul" wrote:

Hi All,

How i could say selection column 1 or 2 etc?

For eg if I select range B2 thru Range E10 in the selection column1
will be B and column 2 will be C

How i can reference them.. say for eg i want cente align column 2nd
column of the selected area?

Thanks




All times are GMT +1. The time now is 07:26 AM.

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