search

AllenMattson / VBA

Code Blocks relating to everything VBA
Http://www.NorthWallApplications.Com
473 stars 150 forks source link

VBA Blanks removal issue #4

Open 05Sandy opened 1 year ago

05Sandy commented 1 year ago

Hello All,

I have written a VBA code to remove blanks in the particular column. But it removing all the blanks and unfortunately its excluding a blank and not removing that blank row. Can you please help me out where i went wrong.

Help me with the code to remove blanks in a specific column.

Thanks for your response

abdullah247 commented 10 months ago

yes, definitely try looping in reverse from last row to first rather than top to bottom as it will not work if there are two or more consecutive blank rows.