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
|