I have a cell where anyone can type an email address, and I want that email address to be the one used in this code. Any help will be appreciated.
Sub emailme()
ActiveSheet.Copy
ActiveWorkbook.SendMail "me@myisp.com ", "Hi this is a test"
ActiveWorkbook.Close False
End Sub
"The reward of one duty done is the power to fulfill another"
Jr Cl
wn
Sub emailme()
ActiveSheet.Copy
ActiveWorkbook.SendMail "me@myisp.com ", "Hi this is a test"
ActiveWorkbook.Close False
End Sub
"The reward of one duty done is the power to fulfill another"
Jr Cl
![[atom] [atom] [atom]](/data/assets/smilies/atom.gif)