N
NickHK
Excel 03:
Any ideas why some NumberFormat strings fail ?
e.g. "$"#,##0_);("$"#,##0)
Application.FindFormat.NumberFormat = strFormatString
Seems to error when a non-custom string is applied.
Found an old post from keepITcool to get the list of Built-in numberformats,
but prefer not to go that way.
'Newsgroups: microsoft.public.Excel.programming
'Date: Thu, 01 Jul 2004 16:21:46 -0700
'Local: Fri 2 Jul 2004 07:21
'Subject: Re: Leo Heuser format cleanup code, and a question
NickHK
Any ideas why some NumberFormat strings fail ?
e.g. "$"#,##0_);("$"#,##0)
Application.FindFormat.NumberFormat = strFormatString
Seems to error when a non-custom string is applied.
Found an old post from keepITcool to get the list of Built-in numberformats,
but prefer not to go that way.
'Newsgroups: microsoft.public.Excel.programming
'Date: Thu, 01 Jul 2004 16:21:46 -0700
'Local: Fri 2 Jul 2004 07:21
'Subject: Re: Leo Heuser format cleanup code, and a question
NickHK