Hi:

You are mixing formulas and values in the same expression. Try (untested):

FTDRange.Cells(i).Value = FTDRange.Cells(i).Offset(, -1).Value / findrange

Regards,

Vasant.

"Kobayashi" wrote in message
...
I'm still new to this which might explain why I'm making such a pig's
ear of the below!

I am trying to perform an equation that divides that value in one cell
by the value in another. 'Findrange' is the range of the cell that has
the absolute value that I wish to divide by. RC[-1] is the relative
position that contains the value that I wish to have divided by the
value in the Findrange variable.
However, I simply cannot get this to work!


My code is as follows:

For i = 1 To FTDRange.Cells.Rows.Count
FTDRange.Cells(i).Value = "=rc[-1]" / findrange
i = i + 1
Next i


Any ideas???

Adrian



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/