removing blank rows by macro

Hi guys

Im looking to remove blank rows that have no data in within rows 22-40.
The thing is they technically have something in the cell as they have a formula in them which populates from another sheet.
so in sheet quote cell a22 I have the following formula ='Input Page'!C6

so if cell input page c6 is empty then so will sheet quote cell a22 excluding the formula

is there anyway I can delete these rows by macro if the rows are "empty"

thank you

Pick one column that you consider empty and use that as a reference to delete the row.

don't understand what youre trying to say

Pick one of the cells in the row that you consider to validate the row as having data. Use that as a starting point.

For example:

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

neither works guys

what has column c to do with it? im lost?
column c will always be empty

Column C was an example. You will determine which column.

Can you post a sample file, with some dummy data which does respond to the macros provided?

Assuming that you got headings in cell A1 and in the rows you got formulas the formula value is 0 if there is no value in the "Input page" you could test a macro like this.

Please Login or Register  to view this content.

Alf