| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a column to a selection
I have a spreadsheet that has data in columns A - D in a
varying number of rows. It may or may not contain data in Column E. I want to print columns A - E. I can write a macro to select the data in columns A - D using: Range (("A4"), range("D4").end(xlDown)).Select How do I select this additional column (column E) also? .. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add a column to a selection
Hi Pam
Range(("A4"), Range("E" & Range("D4").End(xlDown).Row)).Select You can use this to print this range Range(("A4"), Range("E" & Range("D4").End(xlDown).Row)).PrintOut -- Regards Ron de Bruin http://www.rondebruin.nl "Pam" wrote in message ... I have a spreadsheet that has data in columns A - D in a varying number of rows. It may or may not contain data in Column E. I want to print columns A - E. I can write a macro to select the data in columns A - D using: Range (("A4"), range("D4").end(xlDown)).Select How do I select this additional column (column E) also? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro help - add column selection | Excel Worksheet Functions | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Automate column selection | Setting up and Configuration of Excel | |||
| Last column in selection | Excel Programming | |||
| Macro column selection | Excel Programming | |||
Linear Mode
