Thread: Setting varible to equal values of a # of cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Setting varible to equal values of a # of cells
Sub RWB()
Dim RWB As String
Dim i As Integer
For i = 1 To 50
RWB = RWB & Range("A" & i).Value
Next i
End Sub

All the Best
Carim

Reply With QuoteReply With Quote