Hi.
I am pretty new to VBA, and have been struggling with a function for a while. I am trying to add two cells from two different sheets, and place the subract in a specific cells on a sheet. I am doing this about 600 times, so I probably need a loop. I know how to do it if only pasting the result in number, but what make this difficult is how I can have the result in formula like (='R'!E38+Sheet10!C34) and not just like (-0.0098292834). I am using loop so the placing of result and the summation cell must also be changing.
THanks in advance for all the help.
Kind Regards
I am pretty new to VBA, and have been struggling with a function for a while. I am trying to add two cells from two different sheets, and place the subract in a specific cells on a sheet. I am doing this about 600 times, so I probably need a loop. I know how to do it if only pasting the result in number, but what make this difficult is how I can have the result in formula like (='R'!E38+Sheet10!C34) and not just like (-0.0098292834). I am using loop so the placing of result and the summation cell must also be changing.
THanks in advance for all the help.
Kind Regards