I am hoping someone can help. I need to use an excel function in a VBA program, but within the function I need it to divide 2 cells. This is done in a for next loop and I need it to do the division down a column. I have been able to use the function in one cell but I can't figure out to have it move down the column.
The line I have is:
Worksheets("Sheet1").Cells(a, 10).Formula = "=exp(-h2/i2)"
I need the -h2/i2 to change to h3/i3 when the loop goes to the next cell and so on.
I hope someone can help or give me an idea of where to go next for the information.
Thanks in advance.
Bookmarks