| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete entire rows by selecting different text in column A | Excel Discussion (Misc queries) | |||
| Keyboard shortcut or selecting entire column | Excel Worksheet Functions | |||
| Selecting An Entire Row. | Excel Programming | |||
| select cell rather selecting entire row | Excel Programming | |||
| problem selecting entire column | Excel Programming | |||
Linear Mode
