Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CurrentRegion.Address | Excel Programming | |||
currentregion | Excel Discussion (Misc queries) | |||
CurrentRegion less one Row | Excel Programming | |||
CurrentRegion | Excel Programming | |||
CurrentRegion Selecting | Excel Programming |