I have this code.
Dim BenefitName As String
Dim Category As String
BenefitName = Sheets(“Benefits”).Range(“B10”).Value
Category = Left(Sheets(“Benefits”).Range(“F10”).Value, 1)
I have created a named range for B10 (ben1name) and a named range for F10 (ben1cat) and I want to use them in the code instead of the actual cell addresses, but I can’t work out how to do that. How do I assign the value of ben1name to BenefitName, and assign the first letter of ben1cat to Category? Any advice much appreciated.
By: David Pannell