Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I'm getting crazy with something that looks very easy.
I've a cycle like this:
Now, I've to write the value
in
(and this part is ok), but also in the same cell of a different sheet, say
How can i figure this out?
I'm getting crazy with something that looks very easy.
I've a cycle like this:
VBA Code:
For Each cell In rec.Range("A2:A" & lr)
...
cell.Offset(0, counter).Value = cell2.Offset(0, 5).Value
...
Next cell
Now, I've to write the value
VBA Code:
cell2.Offset(0, 5).Value
VBA Code:
cell.Offset(0, counter).Value
VBA Code:
Dim cent As Worksheet
Set cent= ThisWorkbook.worksheets("Centralised")
How can i figure this out?