Hi Harris,
One could also write the formula to be;
=if(isna(A1),0,A1)
A1 is the reference of your Formula, so it could be anything from a
sum to a lookup and so on.
Thanks
Andre
On Aug 6, 8:31 am, harris a wrote:
> Hello,
>
> In case a formula is returning “#N/A” then is there a way by which
Hi Jack,
The Active-x textbook doesn't have a limit other than the resources
available on that machine.
You could set the TextBox.maxlength = 0 which is the default for any
number of characters.
Hope this helps
Andre
On Aug 6, 10:19 am, Jack wrote:
> I have a text box on a user form but i nee
Hi there,
There is an easier way to do this as well with a single line of code
in the Worksheets OnChange event,
Target.EntireRow.Select
It works pretty well.
Cheers
On Aug 4, 2:12 pm, Paul Schreiner wrote:
> I don't know that there is any OPTION for this, but
> I have done it before with a
