Dear all,

Sorry for my typo in the example(Sheet2). On the Row4 and Column 13, '31.9'
should have been placed instead of '51.0.'

Thanks in advance,

Jong

"Jong" wrote in message
...
I am totally new to Excel VBA.
...........
corresponding cells(R1C1 format) on another sheet, for example, Sheet2 of
the same Excel book.
For example(Sheet2)
1 2 3 4 5 6 7 8 9 10 11 12 13
1
2 23.1
3
4
51.0
5
6 51.0
...