Hello,

In my Excel I'm transposing large set of data and I need to keep references as they were before transposing. For this I need following:

I want to offset references in formula in my VBA code, doesn't matter if absolute or relative, but offset only references that are on current sheet. References to other sheets should remain as originaly were.

Example:

= A1 + $B$1 + KF1001 + SUM(C2:C5) + sheet2'SUM(C2:C5)

I have offset (3,2)

Result should be

= C4 + $D$4 + KH1004 + SUM(E5:E8) + sheet2'SUM(C2:C5)

Can somebody help me with coding? I'm stuck.

Thank you, Grho