Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem with cell references, eg I want to give values to cells
belonging to a list starting with: Worksheets(rapportWorksheet).Range("R11C6") . I then want to refer to the cell under the cell that was last referred to. Eg R11C6, R12C7, R13C8 etc. I want to have a variable that increases all the time, like: Dim i as long i= 11 R[i]C6 = "First" i=i+1 R[i]C6 = "Second" i=i+1 R[i]C& = "Third" etc...You get the picture. But how do you write that in code using the R1C1 reference style. The code I wrote here I just made up. PLease help me out! Thank you very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |