Hi all,
I could use a macro that deletes all blank row in a range of all the sheets from the seventh sheet.
for example:
the seventh sheet then there are these sheets :
cagliari
milano1
milano2
torino
roma1
roma2
roma3
in each sheet for each row there is a number ranging from 1 to 200 .
The macro should delete blank row that are included between 1 and 200 for each sheet .
Obviously leaves filled to not be touched .
For example in cagliari the last row is full the n ° 80 , then should be deleted rows from 81 up to 200.
I do not know if I was clear, however, attach two examples one before using the macro that I would use and one after using the macro.
thank you.
I could use a macro that deletes all blank row in a range of all the sheets from the seventh sheet.
for example:
the seventh sheet then there are these sheets :
cagliari
milano1
milano2
torino
roma1
roma2
roma3
in each sheet for each row there is a number ranging from 1 to 200 .
The macro should delete blank row that are included between 1 and 200 for each sheet .
Obviously leaves filled to not be touched .
For example in cagliari the last row is full the n ° 80 , then should be deleted rows from 81 up to 200.
I do not know if I was clear, however, attach two examples one before using the macro that I would use and one after using the macro.
thank you.