macro to find first blank cell in rows and insert text

i need a macro to find the first empty cell in a column and insert text, then in the cell after that one insert another text

I need this to loop through as many columns as a column count function i have states

Something like this perhaps:

Please Login or Register  to view this content.

it doesnt work

Likely b/c i have formulas in teh cells returning ""

i need a macro to find the first "" in a column and then insert text, then insert diff text after that.

Try this then

Please Login or Register  to view this content.

that works but i need it to stop if theres no data in the next colum in row 17

Okay then.....

Please Login or Register  to view this content.

Is there anything else you want to tell me? This would be easier if the constraints were made known.

worked great. Thanks