Referencing two cells in a msgbox

[trexanderson]

I need some help referencing two cells in a msgbox,this example only gives me the first cell value. Can I add a text string to this also?
Examples would be very helpfull.

MsgBox Sheets("Ogden to Howell hand holes").range("I11,I10").Value

[Ian Mac]

On 2002-05-24 11:35, trexanderson wrote:
I need some help referencing two cells in a msgbox,this example only gives me the first cell value. Can I add a text string to this also?
Examples would be very helpfull.

MsgBox Sheets("Ogden to Howell hand holes").range("I11,I10").Value

Here is an example of what you could use

MsgBox "Ian " & Sheet1.Range("d1").Value & " " & Sheet2.Range("d1").Value & " Whatever"

as for put a range of cell, e.g. D1:D3, I'm not sure.

[trexanderson]

Thanks for the example, it works good,.