Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |