Blianking Empty Lines In a Report

[imageres]

I am working on an estimating, quoting and invoicing aplication for th
landscaping business. The App is largely completed with one exception
I want to be able to produce client quote/invoice from the various wor
sheets in this app. without having to manually edit each line. However
the problem comes when there is no data in a given cell in the wor
sheets - my quote I end up with a lot of blank line in th
quote/invoice. What I am looking for is a function that will look a
each of the lines in my work-up work sheets, determine if there is dat
in them and if there is print a line item on the quote/invoice. I
there is no data then the program should skip that item and move on t
the next and so on and so on. In another program that I have used thi
feature is know as "blank line suppression" :confused

 

[Art Du Rea]

-----Original Message-----

the problem comes when there is no data in a given cell in the work
sheets - my quote I end up with a lot of blank line in the
quote/invoice. What I am looking for is a function that will look at
each of the lines in my work-up work sheets, determine if

there is data

Esteemed Compatriot ...

You may be looking for "CurrentRegion" and "UsedRange".

Range("A1").CurrentRegion > returns the range including
the reference cell bounded by empty rows and empty colums.

ActiveSheet.UsedRange > returns the entire used range,
including any embedded blank rows or columns from the
farthest upper-right to the farthest lower-left cell.

I found these at:
www.microsoft.com/officedev/articles/Opg/004/004.htm

It seems to me that "CurrentRegion" will find empty rows
for you! Good luck!

Blessings in abundance, all the best, and ENJOY!

Art Du Rea Carlisle, PA USA