delete rows

[max_max]

Hello to all.
In workbook attached there are blank lines in sheet1
6-7-11-19-34-35-39
with a macro you have to eliminate them, formatting to alternating rows (whith macro) must remain.
It must be like in Sheet2
A help?
Thanks in advance.
max_max
----------------------------------------------------------------------------------------------------
Ciao a tutti.
Nel workbook allegato ci sono delle righe vuote in foglio1
6-7-11-19-34-35-39
con una macro bisogna eliminarle, la formattazione a righe alterne (whith macro) deve restare.
Deve risultare come nel foglio2
Un aiuto?
Grazie in anticipo.
max_max

[Greg M]

Hi there,

See if the attached workbook does what you need.

The workbook uses the following code:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[vichopalacios]

I've modified a bit your code to match your requirements.
Try it to see if it works

Please Login or Register  to view this content.