Macro error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

orquidea - 20 Dec 2007 00:19 GMT

Hi All:

I want to get the result in saskour20per as a percentage. I wrote the below
procedure which is generating the error "invalid qualifier".

Saskour20per.Value = (saskour20 / sask20)
Saskour20per.NumberFormat = "0.00%"

Could anyone help me to debug this macro?

Thanks in advance
Orquidea

Reply to this Message

Gary''s Student - 22 Dec 2007 12:34 GMT

Your code will work if Saskour20per is a Range variable that has been
assinged a value. The values of the numerator and denominator must also be
established as well. Something like:

Dim Saskour20per as Range
Set Saskour20per=Range("A1")
Saskour20per.Value = (saskour20 / sask20)
Saskour20per.NumberFormat = "0.00%"

Signature

Gary''s Student - gsnu200761

> Hi All:
>
[quoted text clipped - 8 lines]
> Thanks in advance
> Orquidea

Reply to this Message

orquidea - 22 Dec 2007 19:24 GMT

thanks for your answer.

> Your code will work if Saskour20per is a Range variable that has been
> assinged a value. The values of the numerator and denominator must also be
[quoted text clipped - 17 lines]
> > Thanks in advance
> > Orquidea

Reply to this Message