Name Range with using Data Form

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

I first created a variable with A1:D1, four columns with named variable
Data. How to expand this Data range to A1:D2 after using the DataForm to add
one row data in the worksheet?? The same, the Data range should be A1:D3
when adding one more data row...

million thanks
 
Hi
use the following formula in the name definition dialog
=OFFSET($A$1:$D$1,0,0,COUNTA($A:$A))
 
Back
Top