Hi
I am declaring this as a string but I get a debug type miss match error.
Dim ProposalYear As String
ProposalYear = Worksheets("Calculation Matrix").Range("L41:M41").Value
L41:M41 is a merged cell is this the best way to declare this.
Thanks
I am declaring this as a string but I get a debug type miss match error.
Dim ProposalYear As String
ProposalYear = Worksheets("Calculation Matrix").Range("L41:M41").Value
L41:M41 is a merged cell is this the best way to declare this.
Thanks