Add a column to a selection

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

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?
..
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Recorded macro selection widened 4
Transfer array element offset value to a matched value 3
Macro Button to Sort Columns - Troubleshooting ideas? 1
ERROR 400 on identical codes different range 8
File Name changes with dates and Deleting Rows of Zeros 0
Find a value in a sheet and replace it with another value if it matches 8
Resize Range for Column 3

Back
Top