Dear macro experts
I am setting up my financial model and trying to write a simple macro to do go seek on my speadsheet.
My problem is
to calculate values in row 1 in order to make Row 2 zero.
it is easy to use go seek, but i need to run it one more than 50 columns, i.e. from A1 to A50. Can anyone help me on the macro code? I never write a macro myself, its the first time trying.. Thank you so much!
I am setting up my financial model and trying to write a simple macro to do go seek on my speadsheet.
My problem is
to calculate values in row 1 in order to make Row 2 zero.
it is easy to use go seek, but i need to run it one more than 50 columns, i.e. from A1 to A50. Can anyone help me on the macro code? I never write a macro myself, its the first time trying.. Thank you so much!
