In a program, I have
n=500
application.screenupdating=false
For i=1 to n
cells(i,6).value=cells(i,5).value*35
cells(i+n,6).value=cells(i,4).value*76
next i
application.screenupdating=true

This takes an age to run, especially if n is really large.

There must be a faster (better) way of doing this - can anybody help please?

Thanks
Chris