I am importing some data with a MS QUERY from another workbook and the data is put into a table called CUSTOMERS.
The listobject has several columns and one of them is "First Order Date".
There is one value that I want to remove (not hide with a cell format): 00.01.1900 00:00:00
Is there a neat way to delete this value in the entire listobject with VBA?
I do not mind if the data is converted to a string if that makes it easier and the cell is empty
Thanks
Massimo
Microsoft ExcelVBAMicrosoft Office
Last Comment
Shums Faruk
8/22/2022 - Mon
Rgonzo1971
Hi,
pls try
Sub Macro1()Application.ScreenUpdating = FalseFor Each c In Range("Table1[First Order Date]") If c.Value = 0 Then c.ClearContents End IfNextApplication.ScreenUpdating = TrueEnd Sub
pls try
Open in new window
Regards