Hi,
i have a lot of listobjects in one worksheet and what want to achevie is to clear formats from them.
I recorded macro:
But you can see for each listobject there is separeted statement. It is possible to do it in one command?Selection.ClearFormats ''here i am selecting whole worksheet ActiveSheet.ListObjects("t_Ips").TableStyle = "" ActiveSheet.ListObjects("t_DnsSource").TableStyle = "" ActiveSheet.ListObjects("t_SharedStorages").TableStyle = "" ActiveSheet.ListObjects("t_Subnets").TableStyle = "" ActiveSheet.ListObjects("t_ResourceGroups").TableStyle = "" ActiveSheet.ListObjects("t_TierAutomations").TableStyle = ""
Best,
Jacek
Bookmarks