gwpatton
07-09-2010, 11:44 AM
Hi I am relatively new to using VBA, I have been playing around with simple commands and have reached the limit of what I can do. I am looking to perform a calculation of data using VBA that will do the same thing as this formula in excel 0.5*(G31+G30)*(H31-H30)+I30 returning only the a value in column P starting in row 31. This operation will need to be applied to the entire range of data in columns G and H starting in row 31
I don’t even know where to start on this, any help would be appreciated.
Thanks
I don’t even know where to start on this, any help would be appreciated.
Thanks