Date
1 - 3 of 3
EPPlus - Formula
|
Pavel Mencl
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 |
|
|
|
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:
|
|
|
|
Pavel Mencl
Problem solved,it was the missing =.
THANK YOU
Pavel
|
|
|