| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
