MS Excel / VBA help thread

You are reading a single comment by @greentricky and its replies. Click here to read the full conversation.

•

hugo7 in reply to @greentricky

The latter.

•

greentricky in reply to @hugo7

That's easy then, select entire sheet, ctrl+G, special,blanks, delete, shift left

•

hugo7 in reply to @greentricky

Agh! It's just been too long a week!

Yeah of course.

To quickly delete the blank rows I was just going to filter the first column removing blanks then paste into a new sheet. Is there a faster /more smart way?

About

Avatar for greentricky @greentricky started