Posted to microsoft.public.excel.programming

orquidea

external usenet poster

Posts: 132

Percentage formating 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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro fails to produce Category Name and Percentage values - Pie C	Jay	Charts and Charting in Excel	5	June 19th 09 09:24 AM
Formating percentage in macro	orquidea	Excel Discussion (Misc queries)	2	December 19th 07 01:38 AM
formating macro	vishu	Excel Discussion (Misc queries)	6	June 15th 05 01:02 PM
macro to calculate percentage	vikram	Excel Programming	5	May 3rd 04 04:02 PM
Formating Macro	Brady Snow	Excel Programming	2	November 4th 03 04:18 PM

All times are GMT +1. The time now is 12:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us