Crispo14

PI with VBA excel

Discussion created by Crispo14 on Nov 20, 2014
Latest reply on Dec 10, 2014 by rkoonce

Hi to Everyone

I'm trying to apply a PI formula into excel spreadsheet with VBA by this code:

 

 

Sheets("Foglio1").Cells(6, 1).Select
ActiveCell.FormulaR1C1 = "=PISampFilDat(R1C3,R1C1,R2C1,R4C1,R2C5,R1C2,R2C2,R3C1)"
 
my output is this:
                    Resize to show all values           

 

How can resize automaticaly ??

 

Thanks

Outcomes