Next empty cell in table column M

[isaacv22]

Hello,

I'm trying to figure out how to get this formula to find the next empty cell in a table. It was working fine before I had converted my data into a table and the previous formula is below. I would like this function to work while the data is in a table.

Sub Next_Empty_Row_M()
'
'selects the next empty row
'ignores blanks inbetween the data set

Range("M" & Rows.Count).End(xlUp).Offset(1).Select
End sub

 

[isaacv22]

I'm trying to have this formula work for the next empty cell in column M which resides in table 1. It worked just find prior to making my data into a table.

Thanks,

Isaac Vasquez

 

[Fluff]

Have you tried the code in post#2?