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?