Hi,
You can enter a formula in 2 ways :

1. a static formula
Cells(1,1).FormulaLocal = "=" & Cells(1,2) & "/" & Cells(1,3)

2. a dynamic formula
Cells(1,1).FormulaLocal = "=" & Cells(1,2).Address & "/" &
Cells(1,3).Address

I hope this helps


---
Message posted from http://www.ExcelForum.com/