1. Messages
  2. EPPlus - Formula

Re: EPPlus - Formula

Harry Kleinsmit
 

Hi Pavel,

Formula's usually start with and '=' sign. So in your case it should probably be:

EvaluateExpression( Worksheet.Cells['A1'].Formula='=Count(B1:B10)' )

Best regards,

Harry Kleinsmit.


On Fri, Apr 28, 2017 at 05:41 am, Pavel Mencl wrote:

Hi,

I'm trying to set a cell to a formula like Count(range)  with

EvaluateExpression( Worksheet.Cells['A1'].Formula='Count(B1:B10)' )

but that doesn't work.

What am I missing?


cheers

Pavel

 
Join {main@magicu-l.groups.io to automatically receive all group messages.