Help finish filtering script

I pull data from a site called NDRIN.com

massive state land database

Well i have a script that works sometimes unless the entrys are messed up


I need it to look like this

Section Township Range
27 155 97
24 157 98
17 155 98
30 159 97
15 155 97
7 158 100



and it works but as the attachment shows that whenever i have a blank entry such as the 6th one, or an entry Legal: that uses subdivisions and lots instead of township,range,section it locks up.

Now i could careless about lots,subdivisions and blank entry's, i want to just keep filtering and getting my data.

Is there a code i can add to disregard entry's without township,range,section??


CNTRL + Z to run macro and u can see that it fails because of a blank entry. If you delete the blank entry(row with the Legal: blank) it works great!!

FullPGscript.xlsm

like a 2 part macro?

let me try this now

did you set another hotkey to run it?

that works, thanks man just wondering why the cntrl z isnt working anymore.

yeah i got it, figured it woulda stayed the same since i just copied the code. Anyways appreciate it will now burn through some reports!