Finging first row of a given column that has data in it.......exclude header

I have this code and it works to find the first row of data in colB where it excludes the header row.

Please Login or Register  to view this content.

However, when i try to make the code more flexible by makeing B1 a variable .....i get a type mismatch........see below

Please Login or Register  to view this content.

I am enclosing an excel file as this usually makes things easier.

Hi welchs101, I had troubles with this line

Please Login or Register  to view this content.

and I think it is because of alphacol. You have to declare alphacol as a range and then set it to B1 first. Let me know if the following does what you want

Please Login or Register  to view this content.

I knew that because After:= means after a range/cell (at least that's what I thought it meant).