View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Message box help

Sub macro1()
Static iRow
'do other stuff
If iRow = 0 Then iRow = 1
iRow = iRow + 1
MsgBox Sheets("Sheet1").Range("A" & iRow)
End Sub

Hth,
Merjet