Hi,
I'm needing to calculate a value using surrounding cells. The VBA formula will need to use relative reference.
activecell.value = dataPage.Cells(xxx, "h").Value
where the xxx's are should be some kind of reference which will seek the the row 1 below the currentactive cell.
Again I can't use absolute references such as
activecell.value = dataPage.Cells(24, "h").Value <-- if i had been activecell = 23
This can't do as I will be autofilling this over several other cells so i need a relative reference. I am new to VBA but i think it might have something to do with R1C2 or something to that syntax.
Thanks in advance.
I'm needing to calculate a value using surrounding cells. The VBA formula will need to use relative reference.
activecell.value = dataPage.Cells(xxx, "h").Value
where the xxx's are should be some kind of reference which will seek the the row 1 below the currentactive cell.
Again I can't use absolute references such as
activecell.value = dataPage.Cells(24, "h").Value <-- if i had been activecell = 23
This can't do as I will be autofilling this over several other cells so i need a relative reference. I am new to VBA but i think it might have something to do with R1C2 or something to that syntax.
Thanks in advance.