I am trying to record a few macros but i am finding that because the data has
variables in it i.e. things that change (column/row number, sheet no etc) the
macro stops working. it is unable to apply itself to a number of different
situations and adjust accordingly, for example, where the column number
changes or the number of rows etc. How can i code the macro to allow for many
different variables?

thanks.

hi.
the macro recorder records all of your actions on the mouse and keyboard
then when you run the macro, it duplicates all of your previous actions. as
you have learned. making a recorded macro generic can vary depending on what
actions you want performed. there is no "one size fits all" solution.
post one of your macros so that we can have a better idea on what your are
trying to accomplish.

Regards
FSt1

"Zak" wrote:

I am trying to record a few macros but i am finding that because the data has
variables in it i.e. things that change (column/row number, sheet no etc) the
macro stops working. it is unable to apply itself to a number of different
situations and adjust accordingly, for example, where the column number
changes or the number of rows etc. How can i code the macro to allow for many
different variables?

thanks.