Hi

I have a spreadsheet with lots of columns & I want to add some up and put in
new columns.

At the moment I am using Find to locate the columns,which is working fine,
but then I need to add the formula to each row. So I know I want to add
cols P & col W and put in col X.
Range("X" & ActiveCell.Row & ":X" & iRow).Formula = col P + col w

Can anyone tell me how to do this ?

Thanks
Jill