DISPLAY RANGE AT MSGBOX

  • Thread starter Thread starter GUS
  • Start date Start date
G

GUS

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
 
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
 
Sub ShowCells()
msg = ""
for each cell in selection
msg = msg & cell.value & vbNewLine
Next
msgbox msg
End Sub
 
Back
Top