Hello All,
I have a workbook that contains worksheets of the same structure and I need to update them monthly with new data.
I used to record macros in Excel 2010 and then run them on the other worksheets with the same structure as the one I recorded the macro on. I am trying to do the same in Excel 2013 but I have issues with it, I get run-time error `1004` (select method of Range class failed). When I click on debug, it highlights the following part: Range("Table1016242934384261222[@Column19]").Select
(Full code is below.)
I have never had this issue in Excel 2010, actually I can`t even remember seeing these long table names consisting of numbers in the codes in Excel 2010.
I also seem to have issues with the relative references in my code.
What could be the problem?
Cheers
Bookmarks