is there a macro to delete empty rows?

[Poseidons-Palace]

Hi guys i know this is probably a simple thing but i don't seem to be able to find a solution anywhere, that is unless i look at third party software.

what i am trying to do is delete all empty rows but leave individual cells in a populated row that are the result of the following group of macros

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

i have uploaded an example of the file output.

Hopefully this will make sense.

[zbor]

try this:

Please Login or Register  to view this content.

[Poseidons-Palace]

I am unable to get this macro working, keep getting an error. Am i supposed to select sheet, column etc???

I am getting the following error all the time, as far as i can tell the macro has been input correctly....

Cells.JPG

If anyone can let me know where the problem is arising i would be very grateful.

I am thinking that even though the cells are blank in some way the macro sees them as being populated, does that make any sense at all???

[AB33]

As an option

Please Login or Register  to view this content.

[Poseidons-Palace]

Exactly what i needed...

Thank you so much

[Poseidons-Palace]

would it be possible to set the code to run based on a cell change in a different sheet?

The reason i ask is because i am wanting the macro to run based on the result of a drop down on another sheet, i have tried inserting a cell (H1) that changes (see below) as the sheet changes but i am still having to go in manually and run the script afterwards.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Again any help would be much appreciated

Jez