Which variable to use

[BobbyJack]

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

 

[SteveO59L]

What is held in L41:M41 ?

 

[Domski]

VBA hates merged cells. Much better use Center Across Selection and then just:

Dim ProposalYear As String
ProposalYear = Worksheets("Calculation Matrix").Range("L41").Value

Dom

 

[Jon von der Heyden]

I hate merged cells and avoid them like the plague! However...

What is returned if you use:

Dim ProposalYear as String
 
ProposalYear = Sheets("Calculation Matrix").Range("[B][COLOR=red]L41[/COLOR][/B]").Text

 

[Yard]

Merged cells are the devil's work.

Suspect you'll have to just refer to L41.

Not sure whether the String data type is particularly bomb-proof when referring to the value of a cell (and will certainly fail if the cell contains an error value).

 

[Jon von der Heyden]

Not sure whether the String data type is particularly bomb-proof when referring to the value of a cell (and will certainly fail if the cell contains an error value).

Hence use .Text property instead of .Value...

 

[Yard]

Oh yeah, of course!

.Text returns the displayed value rather than the held value, right?

 

[Jon von der Heyden]

Kinda, but rather than saying 'displayed value' I'd just say that it returns the String value of the range (when referring to the range that is)...

 

[BobbyJack]

Thanks everyone

I have only taken the first part of the cell "L41" and it is now working

thanks again