Hi

[keerthi4786]

Hi I want to divide respective cells in one column with other column and obtaining the results in next column using cells reference. Here is VBA code i am using
Range(Cells(3, lastcolumn + 6), Cells(5, lastcolumn + 6)).Formula = "=" & Cells(3, lastcolumn + 4) & "/" & Cells(3, lastcolumn + 5)

It is giving same value for all cells it will not dividing respective cells.

 

[Macropod]

keerthi: Please read Guideline A4: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html and edit your thread title accordingly.