ExcelBanter - Unable to set NumberFormat Property of Range class

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Unable to set NumberFormat Property of Range class (https://www.excelbanter.com/excel-programming/386324-unable-set-numberformat-property-range-class.html)

ade

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?

All times are GMT +1. The time now is 01:30 AM.