Hi all,
I'm tryin to write a code to pull a small range of cell into a msgbox. I want to expand it so i can use the code to pull the data from a different workbook.
Here is the code:
Can anyone give me a hand please.Sub ShowRange() Dim msg As String Dim r As Integer, c As Integer For r = 3 To 13 For c = 14 To 18 msg = msg & Worksheets("Sheet 2").Cells(r, c).Text If c <> 18 Then msg = msg & vbTab Next c msg = msg & vbCrLf Next r MsgBox msg End Sub
Bookmarks