Use the dollar sign to fix columns and row like you would on a worksheet.
Maybe you need to fix the worksheet and add the dolar signs.

" wrote:

I am brand new to Macro writing and I' m currently stumped! Trying to
write a Macro that I can use anywhere in a workbook on new or exisitng
sheets.

Attempting to copy a series of formulas (2 rows 25 columns across-
example formula ='RussoDI'!H15) down 2 rows, paste it and change only
the far right letter (H to G which refers to another sheets column).
I would also like to NOT change the cell but when copying, if I
started with H15 it automatically changes to H17. Is there anyway to
write a Macro that copies this range changes only the column letter,
and keep the actual cell #?

Thank you for any insight