Delete and Insert macro with Input Box

[Hyperbole]

Through search from the internal I managed to find a macro that allows me to delete empty rows from a selected range but I would like to make this codes able to accept user input to select the range to perform the task. I would e please to receive some help in this department. The codes are as follows:

Please Login or Register  to view this content.

[rylo]

Hi

Try

Please Login or Register  to view this content.

This will allow you to nominate the range and you can then process based on the selection.

To give an example, run the code, and when the inputbox comes up, select the range A1:A5. You will be shown the 5 addresses.

Please Login or Register  to view this content.

HTH

rylo

[Hyperbole]

I am not well verse with VBA and I would be grateful if you can help by letting me know how can your proposed codes be incorporated into the existing codes to make it works.

Thanks!

[Trebor76]

Hi Hyperbole,

The following should do the trick:

Please Login or Register  to view this content.

HTH

Robert

[Hyperbole]

Hi Trebor76,

Your codes is working great. Thanks!