Selecting an entire column
 

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco

Selecting an entire column
 

Hi Marco,

Try:

Activecell.EntireColumn.Select


---
Regards,
Norman


"Marco" wrote in message
...
I'm trying to write a code that selects the entire column, regardless of
what
cell I'm in. I run a find and sometimes end up in column O or it could be
AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco

Selecting an entire column
 

Sub dural()
ActiveCell.EntireColumn.Select
End Sub

--
Gary''s Student - gsnu200716


"Marco" wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco

Selecting an entire column
 

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco

Selecting an entire column
 

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco

Selecting an entire column
 

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson

Selecting an entire column
 

You sure make it simple. I presume that the paste will paste in columns ABCD
will try it
Thanks Dave

"Dave Peterson" wrote:

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson

Selecting an entire column
 

Works great. How can I start the copy at A:4 useing 4 for all and do the rest
of column. Have some headers in the top 3 rows. Tried to use a:4 and wow.
Thanks

"Dave Peterson" wrote:

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson

Selecting an entire column
 

Addition this is what I tried
Worksheets("Data").Range("A4,D4,E4,G4,L4").EntireC olumn.Copy _
Destination:=Worksheets("Announcer").Range("A2")
Relize entirecolumn isn't right when starting in 4th row Also as you can
see want paste to start on row 2 also
can we do it?
Thanks

"Dave Peterson" wrote:

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson

Selecting an entire column
 

Yea I got it persentance pays off
Thanks

"Dave Peterson" wrote:

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson

Selecting an entire column
 

Glad you got it.

Curt wrote:

Yea I got it persentance pays off
Thanks

"Dave Peterson" wrote:

I like:

worksheets("somesheet").range("a1,D1:e1,G1,L1").en tirecolumn.copy _
destination:=worksheets("othersheet").range("a1")



Curt wrote:

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.
Useing above as reference
How would I select the following. I want to copy these to another worksheet
so will need to copy and paste
Column(A)(D)(E)(G)(L)
Thanks for looking
Help greatly appreciated
Thank You

"JE McGimpsey" wrote:

One way:

ActiveCell.EntireColumn.Select

In article ,
Marco wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco


--

Dave Peterson


--

Dave Peterson