Hello. I have a code that I found on the Internet for removing formula from excel blank cells but it works only for one worksheet with a specific name. I was wondering if someone could change it so it will work for several sheets with different names and ranges. For example sheetA range(a1:b20) , sheetB range(a1:e40), sheetC range(a1:n15)
For Each c In Worksheets("your sheet name").Range("your range")
If c.Value = "" Then c.Select: Selection.ClearContents Next c
I'm sorry the file doesn't belong to me so I don't have the right. It's weird it works but it shows me error number 13 at the end. But anyway it doesn't solve my problem because when I save the file as tab delimited or CSV there are the sign ; in the blank cells containing formulas.