ExcelBanter - Invalid qualifier error in macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Invalid qualifier error in macro (https://www.excelbanter.com/excel-discussion-misc-queries/170266-invalid-qualifier-error-macro.html)

orquidea

Invalid qualifier error in macro

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

All times are GMT +1. The time now is 03:01 PM.