A message box needs a string as an argument. If you give it a one cell
range it will take the text or value of that cell as the string. If you
give it a multi-cell range it does not know how to convert it to a string.
You would need to do that first (perhaps by stepping through the cells in
the range and concatenating their values) and then pass the string to the
message box.