Without seeing what the current region looks like, it would be presumptious
to offer any code. What you would have to do is move the visible data to a
location on the sheet (or a sheet) where it can be grouped or arranged as
you would like to see it printed. I am not so sure it is worth the effort,
but then I have no idea what your requirements are. There is no quick and
easy solution. However, If the data is truncated by column or by row you
might be able to identify the visible range by looking for the last column
or row with a sum greater than zero, or CountA is greater than zero,
depending on what the visible data type is.


"CR" wrote in message
...
All of the cells have formulas. Say, A1:AZ100 At times the visible data
only goes to columns AW or AX or AY. There are no blank cells in the rest
of the area .

If CurrentRegion won't work is there another way?


"JLGWhiz" wrote in message
...
Not if you are going to use the CurrentRegion.Address as the print area
parameters. Excel takes the entire range from top left to bottom right
cells as the print range. You would have to do a little manipulating if
you only want to pring the visible data and I am not sure I have the
expertise to tell you exactly how to do it.


"CR" wrote in message
...
I'm setting a print area using CurrentRegion.

Is there a way to have the current region ignore cells that only have a
formula in them?

Thanks
CR