.NumberFormat is not a method of the Worksheet object. It applies to a Range object. Try defining a range and using Workbook.Worksheets("Sheet1").Range("A1:Z1000").NumberFormat = "@"
If you want to format the entire sheet, you can either define a range that covers the entire sheet, or use Workbook.Worksheets("Sheet1").Columns.NumberFormat = "@" as Worksheet.Columns technically returns a range object that includes all columns.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
