View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default DISPLAY RANGE AT MSGBOX

Something like this maybe.
BTW Please use proper case in you subject line as you were kind enough to
use in the msg.

Sub message()
MsgBox [h1] & vbCr & [h3]
End Sub

"GUS" wrote in message
...
how can i add in a msgbox , a range of cells

I have 10 cells in every range
and i want all the cells to be shown in the msgbox
whenever i run the apropriate macro