Posted to microsoft.public.excel.programming

ade

external usenet poster

Posts: 16

Unable to set NumberFormat Property of Range class

I have code to set the number format for a range but I keep getting the error
message 'Unable to set NumberFormat Property of Range class'.

My code is : Worksheets("InStock").Range("A" & i).NumberFormat = "@".
I can't figure out what is wrong, any ideas anyone?

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
Unable to set NumberFormat Property of Range class	Gary''s Student	Excel Programming	0	March 28th 07 02:43 AM
Unable to set NumberFormat Property of Range class	Ade	Excel Programming	0	March 28th 07 12:59 AM
Unable to set NumberFormat property of the PivotField class	Seb[_5_]	Excel Programming	0	December 6th 04 04:04 PM
Unable to set NumberFormat property of the PivotField class	Seb[_5_]	Excel Programming	0	December 6th 04 03:50 PM
Unable to set the NumberFormat Property of the Range Class - ERROR	Jon Delano	Excel Programming	3	November 10th 04 07:33 PM

All times are GMT +1. The time now is 09:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us