Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am totally new to Excel VBA.
I have a Sheet1 containing Row number, Column number, and value(3columns). For example, Row number Column Number Value ----------- -------------- -------- 2 6 23.1 4 13 31.9 6 4 51.0 ......... and so on. I wish I could relocate the values(23.1, 31.9, 51.0... ) to the 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 .... Would there be any elegant VBA program for doing this instead of Excel function methods? I really appreciate your help or suggestions to this. Jong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro not recording in R1C1 format | Excel Discussion (Misc queries) | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
R1C1 format using a variable? | Excel Discussion (Misc queries) |