Unable to set NumberFormat Property of Range class

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top