simmalbert
09-17-2016, 02:50 AM
Hi Folks,
This is a very general question.I converted my spreadsheet of data to a table.Once converted to a table each column heading has a small down arrow that enables further filtering.I can then run various formulas on the data or filtered data.
Eveything works OK,and it's a really great tool.The problem comes when I try to automate it with a macro.The results are mixed,sometimes no problems at all,other times inconsistencies and on other occasions the completely wrong result,sometimes it can also be very slow.
I have now been told that using Tables with macros is not a very good idea and can lead to all sort of problems and is best avoided altogether.Is this true,is there an alternative?
Any help appreciated on this.
This is a very general question.I converted my spreadsheet of data to a table.Once converted to a table each column heading has a small down arrow that enables further filtering.I can then run various formulas on the data or filtered data.
Eveything works OK,and it's a really great tool.The problem comes when I try to automate it with a macro.The results are mixed,sometimes no problems at all,other times inconsistencies and on other occasions the completely wrong result,sometimes it can also be very slow.
I have now been told that using Tables with macros is not a very good idea and can lead to all sort of problems and is best avoided altogether.Is this true,is there an alternative?
Any help appreciated on this.