Thread: How Do I Display a Range of Cells in A Message Box Using VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel Nerd Excel Nerd is offline
external usenet poster
  
Posts: 1
Default How Do I Display a Range of Cells in A Message Box Using VBA?
Greetings,

I would like to display a range of cells in a message box. The VB
code that I'm using is:

MsgBox ThisWorkbook.Sheets("Calculation ").Range("g9:h19").value

There is something wrong with the range because when I program th
message box to display cell "g9" there's no problem. When I program th
message box to display "g9:h19" there is a problem.

Please Help...

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote