Blianking Empty Lines In a Report

  • Thread starter Thread starter imageres
  • Start date Start date
I

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: :confused
 
-----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
Click to expand...
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
 
Back
Top