I have a 10 formulas that operate along an Excel row. Initially I had

copied the formulas into all rows in a spreadsheet up to row 3000.

However this makes my spreadsheet unnecessarily large. What I would

therefore like to do is copy the formulas ONLY if data is added into

the first column.

Is this possible using VBA?

For example if I have the formula =A1+B1 operating in cell C1 how

could I copy the formula ONLY when data is added to cell s in column

‘A’?

Regards,

Kevin