How to add formulae to cell after advanced auto filter

[rob.callaghan]

Hi, please could someone help?

Im very new to VBA, so this maybe very simple...

i have some code that sorts my data into order using advanced auto-filter and it then selects the cell in which i need the formulae adding, the problem i have is that the formulae i am using includes absolute references and it locks it to that particular cell instead of the first visible cell.

The working bit of the code is;-

Please Login or Register  to view this content.

the formulae i need adding is this but i need the R1253C9 & R1253C14 to be absolute references but not to that cell, if im making sense??
i need them to be locked to rc[-6] & rc[-1]

Please Login or Register  to view this content.

can anyone point me in the right direction ?

thanks

[humdingaling]

confused
not sure if you want to "locked" (absolute) and what you want to be relative
in RC notation removing the [] applies $ in formula

ie putting in A1
=SUM($B$1:$B$5) =SUM(R1C2:R5C2)
=SUM(B1:B5) = SUM(RC[1]:R[4]C[1])

so just remove the square brackets?