adding subtracting etc. columns on a worksheet

[steever]

Hi,

I'm new to this - can someone quickly show me how i might create a column via code that will add/subtract/multiply/divide other
columns on the worksheet. Eg. Column K = ColA + ColB + ColC.
I only want the results of the calculation to show in Column
K if there is data in the rows of ABC, and this can be variable.

Any ideas.

thx all !

Steve

 

[PHV]

Have you tried the macro recorder ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884