Cancatenate the range between two cells in a sheet from addresses of two cells in another sheet

Vote count:

0

I have two cells in sheet1 that contain address for two cells in sheet2. for example in sheet1, the cells(1,1).value has the address $1$6 and cells(1,2) has the address $1$100. These two addresses refers to two cells in sheet2. Now I want to concatenate the range between $1$6 to $1$100 from sheet2.

My code doesn't work:

Sub concatenate()

   Set wss = Sheets("sheet1").Range("sheet2.Cells(1, 1).Value : sheet2.Cells(1, 2).Value")
   For Each cel In wss 
   tval = tval & cel.Value
   Next
   Sheets("sheet2").Cells(1, 7).Value = tval

 End Sub

asked 56 secs ago

javad

17

Cancatenate the range between two cells in a sheet from addresses of two cells in another sheet