Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with VBA
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 |