Run-Time Error when Trying to Populate Cells

Hello All,

I am trying to populate cells with a date that is located next to a cell with the word "Visit."

This is my code:

Please Login or Register  to view this content.

I get a run-time error 1004 (Application defined or object defined error) and when I hit "debug" the part in red font is the problem area.
The weird thing though is when I look at my spreadsheet, the code works. It does what I want. But this code is a small part of a larger macro, so the error causes my macro to stop running. Any and all help is much appreciated!

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

You're getting the error because you're trying to run the code on row 0, which doesn't exist. It's appears to be doing what you want because all the other rows are affected before lRow = 0.

I change "Do While True" to "Do While lRow > 0" and it worked! YAY!! Thank you!