Selecting cells

[elgringo56]

I have a list 6 columns wide and an unknow number of rows in length. Using a macro, I wish to select only the cells within the list that contain data so that I can print it under macro control. Is this possible?

 

[Al Chara]

What about activesheet.usedrange

 

[elgringo56]

That does it, Al. Thanks heaps, I owe you one.