VBA, Delete blank rows with no visible data in Column A

Hi everyone,

I developed an order sheet in excel and wanted to make a packing slip on another tab for future tracking purposes. I created the order sheet and named it Thermafoil and on another sheet labeled "info" I developed formulas that will show the order information if the quantity (column B) on the sheet "Thermafoil" has a value . However, this leaves me with a bunch of blank rows on the info sheet. I have tried searching everywhere for a code that will automatically delete the blanks rows if there is no info in column A of the "Info" sheet.

Any help or pointers will be much appreciated.

Thanks in Advance!

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Maybe:

Please Login or Register  to view this content.

I think you meant this instead.

Please Login or Register  to view this content.