VBA - Mark cell with Email Sent

[blimey88]

Hello all,

I have created a user from that is automatically checking for out of date dates and automatically creating the emails and currently displaying them before being sent. I need to be able to mark the next empty cell as 'Email Sent' to indicate that the email has been sent for that specific data/document? Any help would be appreciated

 

[onlyadrafter]

Hello,

a clearer explanation is required. Which next empty cell, next from where

Range("A1").Offset(0, 1).Value = "Email Sent"

perhaps something like this?

 

[blimey88]

Sorry the vague question, I have figured out the code needed, using an offset function not dis similar to your example above. Many thanks for the help