Hi,
I'm new to macro writing and have come across a problem and would like some help.
My macro runs and asks the user to open another file and copy the content of column A down to the last row, into the file the macro was launched from.
This bit is no problem so far.
I now need to create a formula using a macro:
I have 3variables, which change for different files;
FirstRow
LastRow
and UserRate
FirstCell and LastCell contain row numbers and UserRate a single digit
The formula I need to recreate with a macro is shown below
=0.03*(1695-32)
Unfortunately I have no idea how to create the formula using the variables;
=UserRate/1000 * (LastCell-FirstCell)
I would appreciate some pointers.
I'm new to macro writing and have come across a problem and would like some help.
My macro runs and asks the user to open another file and copy the content of column A down to the last row, into the file the macro was launched from.
This bit is no problem so far.
I now need to create a formula using a macro:
I have 3variables, which change for different files;
FirstRow
LastRow
and UserRate
FirstCell and LastCell contain row numbers and UserRate a single digit
The formula I need to recreate with a macro is shown below
=0.03*(1695-32)
Unfortunately I have no idea how to create the formula using the variables;
=UserRate/1000 * (LastCell-FirstCell)
I would appreciate some pointers.