Automatically Set Print Range if Cells Contain a Value >1

maic15

Active Member
Joined
Nov 17, 2004
Messages
313
I have a worksheet "Introduction", which contains all text and no numbers. I want to create a macro that sets the print area range for cells that contain text only.

Is that possible?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,118,676
Messages
5,573,603
Members
412,538
Latest member
mrjack
Top