Hi all,

Is there a way to design a macro so that it will function from the Active cell and then affect cells in specific relations to that cell instead of having macros that only affect the exact cells you recorded in your macro?

For example, i want to be able to affect the active cell, and then move over to cells to the right, enter a formula, and then down two to enter another formula. All I can get now is a macro that will do this, but only do it to the specific cells I recorded them in. So, when I record it in A1, and then C1, and then C3, I can't use this macro to affect B1, and then D1, and then D4.

Any thoughts on this?
Thanks much,
Joshua