Dynamic Range - Electronic Signature

[tomexcel1]

Hi All

I currently have a simple code (below) that creates an electronic signature on a document.

I have a formula in Cell S2 that tells me the row the signature should be on. For example on row 309. how can i incorporate this in to my code so that if someone deletes two rows and now the signature needs to be on row 307. I can make the formula in cell S2 update to 307 but cant think how to add it to the vba to make it dynamic.

Can anyone help and im I just overthinking this

Private Sub CommandButton3_Click()
Sheet1.Unprotect ("PASSWORD")
Sheet1.Range("D309").Value = Application.UserName & " - " & Now
Sheet1.Protect ("PASSWORD")
End Sub

Thanks
Tom

 

[Fluff]

Try

Sheet1.Range("D"&Sheet1.Range("S2").Value).Value = Application.UserName & " - " & Now