Help with renumbering column

  • I am working with a sheet 150 rows by 25 columns wide. Column A is my row # column. I need to delete all rows with a blank in column M. I have a macro to do that but it also removes the corresponding # in column A. I would like to have this first column renumber after the blanks are removed. Any suggestions. Thanks.

  • Use the Macro Recoder to compile your new macro, elsewise, post your macro that you use to delete rows with blank M column if you need other help.

  • Assuming your data starts in row 1, try:

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!