Either:orCellValue = ThisWorkbook.Sheets("FORM").Range("D14").Value & "-" & ThisWorkbook.Sheets("FORM").Range("E8").ValueWith ThisWorkbook.Sheets("FORM") CellValue = .Range("D14").Value & "-" & .Range("E8").Value End With
Either:orCellValue = ThisWorkbook.Sheets("FORM").Range("D14").Value & "-" & ThisWorkbook.Sheets("FORM").Range("E8").ValueWith ThisWorkbook.Sheets("FORM") CellValue = .Range("D14").Value & "-" & .Range("E8").Value End With
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.