Add a column to a selection

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?
 
D

Debra Dalgleish

If there's no other data on the sheet, you could use:

Range("A4").CurrentRegion.Select
 
M

Mark

Columns("A:E").print

Excel only prints text, it will not print, or send to
printer excessive sheets that are blank.

So selectiong all the columns means that you do not need
to worry about printing 32,767 rows of almost blank data.
 
Top