Need a Macros that will find a certain row to change formula. Row is not always the same

[Caileanbw]

Hi,

I have built an excel template that has gone out to ~60 users. I have 2 formula errors in the template and I would like to build a macros that they can cut and paste into the template to fix the formula instead of fixing manually and sending back out. I am able to fix one formula but I can't figure out how to change the 2nd. The row that needs to be updated is not on the same row in each template. It's in the middle of the spreadsheet so I can't reference the first or last row. How do I search for the right row to fix the formula? In the row in column A, it's titled "Raises" and then the formula is in column M. I've tried to do a find "Raises" and then tab over to column M, while recording but that doesn't work. Anyone have any ideas?

Thanks,
CMc

[greggpetersen75]

1. Is the name of the range of the formula always the same? Do you use name references in your formula?

[Caileanbw]

Hi Gregg,

The range of the cells are not named, but the range is always starting in column M through X. It's just that each spreadsheet is in a different row.

[Caileanbw]

Also, it's always the 4th row above the last used row but I can't get it to EndUp and then go up 4 cells.. not sure if that helps.

[greggpetersen75]

Please Login or Register  to view this content.

Try this and let me know

Thanks,

Gregg

[Caileanbw]

That worked perfectly!! Thank you so much Gregg!!

[greggpetersen75]

You are welcome. If I have helped you could click that little star to add to my reputation and go to the top of this thread , click on thread tools and click solved.

Thanks,

Gregg