Hi,
I have an issue with cell referencing.

The cells I need to reference are currently in columns J:J and K:K, (J
and K3).

I reference these cells from (S3) and have a basic formula in place t
populate (S3).

The issue is that the cells I reference can change every week from (J
and K3) or to (H3 and I3), for example. Also the cell that I populat
using data from the two cells can also change from (S3) to (P3), fo
example.

Once I establish the first two cells I need to reference I then ( a
the moment) copy and past the formula to populate the records belo
(S3), which uses data from cells below (J3 and K3). All this is done i
VBA using R1C1, which is great when the cell values are fixed.

What I can't work out is how to reference the two variable positio
cells that I will be having. I am thinking of a loop, but withou
having reference to the variable cell positions, I am not sure how t
proceed.

One thing that may help is that there is a heading above both the cell
that I reference that does not change.

Any ideas out there

--
Fastbik
-----------------------------------------------------------------------
Fastbike's Profile: http://www.excelforum.com/member.php...fo&userid=2670
View this thread: http://www.excelforum.com/showthread.php?threadid=50814