Putting formulas in Private Sub Worksheet_Change(ByVal Target As Range)

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Instead of dragging down your formulas the standard way on the
spreadsheet itself. How would you inplement the code in the Worksheet
itself. I'd like for... Once A3 has a date input, for all the formulas
to be automatically pasted into that same row. Once A4 has a date and
so on. "D" thru "K" all have formulas in them. Thanks in advance!!
 
You could do that but might be easier if you use no code at all.

In D1:K1 enter =IF($A3="","",your formula)

Drag all down as far as you wish.

Only have to do this once.


Gord Dibben MS Excel MVP
 
Back
Top