Thebatfink
Active Member
- Joined
- Apr 8, 2007
- Messages
- 410
Ok, so I have this ..
I also want to get the value of a cell offset from the current cell in the For / Next iteration. I use..
and it errors.. I thought mycells would hold the cell reference, but it seems to hold the cell value (hence my offset errors). So I know I can get the cell location using..
but I can't add .offset.value to the end of that because it errors.. So how do I actually get the value of the cell, 5 cells to the left of the current cell being used in the For / Next iteration!!
Thanks
Code:
For Each mycells In Sheet4.Range("o6:o68").Cells
....
Next
I also want to get the value of a cell offset from the current cell in the For / Next iteration. I use..
Code:
mycells.offset(0,-5).value
and it errors.. I thought mycells would hold the cell reference, but it seems to hold the cell value (hence my offset errors). So I know I can get the cell location using..
Code:
mycells.address
but I can't add .offset.value to the end of that because it errors.. So how do I actually get the value of the cell, 5 cells to the left of the current cell being used in the For / Next iteration!!
Thanks