Advertisement
adgwfs

#1bETI7cJ (Office)

Oct 26th, 2023
309
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub test()
  2.  
  3.     For i = 1 To ThisWorkbook.Sheets.Count
  4.         With ThisWorkbook.Sheets(i).UsedRange
  5.             .NumberFormat = "General"
  6.             .Value = .Value
  7.         End With
  8.     Next i
  9.  
  10. End Sub
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement