Any good VBA gurus here? In Excel, I've got some VBA script which I'm using - but how do I assign a variable to a cell value? ie, in cell A1 is an email address - in the vba, how do I assign the variable email_address to read the value of cell a1? Also - it's needs to be the actual value - and not the formula in the cell!
many ta's!
Email_Address = Range("AJ3")
Open_book = ThisWorkbook.FullName