Unable to set NumberFormat Property of Range class

A

Ade

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Unable to set the LineStyle property of the border class" 4
.find does not find if .NumberFormat = "#,##0.00" 2
unable to set the locked property of the range class 8
Unable to change NumberFormat Property 2
How to apply NumberFormat to control on a Userform? 3
Snag in invoice generator. How to change the "series" 5
How to change parts of Cells().NumberFormat 5
Unable to set the LeftHeader property of the PageSetup class 7

Top