Help with code efficiency - routine takes WAY too long to run

I'm a VBA novice. I have a spreadsheet with 5 columns of data in columns A through E with any number of rows (usually thousands). The problem is that for some of the rows the data is shifted to the right one column (in columns B through F). I wrote a macro to shift the rows that were off; the macro evaluates each row and if column A is empty, it cuts the 5 cells to the right and pastes them and then moves to the next row, if not empty it just moves to next row. What I came up with works, but takes way too long and heats up my laptop. I've searched ways to make the code more efficient, but have not come up with something that does the trick.

I'm requesting two things. First, given the code I have (the process of checking each row one by one), is there something I can do to make it run faster? Even if there is a better way to approach this, I'd love to learn how to make something like this faster if that is possible.

Second, I know there has to be a better way to approach this. Any suggestions will help me learn how to do things better.

Thanks in advance.
Doug

Please Login or Register  to view this content.

do you care about the format? if not maybe

Please Login or Register  to view this content.

@ robertsfd2002

Please use Code Tags when posting code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Also you might consider using For Each ... Next loop instead of For x = y... Next which is slower then For Each.

Please Login or Register  to view this content.

woops... I should have included one more cell in the range A:F and B:G (or tidied up as I assume you did).
thanks for the feedback.

Glad to help and thanks for rep+.