Forum Discussion
Solved
VBA Help with Dim and Set tables using listobjects.
Trying to set a table with listobjects, and it comes up with runtime error '438': Object doesn't support this property or method. please help if you can, my code is below and it highlights the row "...
ws1, ws2 etc. are already defined as worksheets of wb, so you should not use wb.ws1, wb.ws2 etc. Just ws1, ws2 etc. is sufficient:
Set tb1 = ws1.ListObjects("Totals")
ws1, ws2 etc. are already defined as worksheets of wb, so you should not use wb.ws1, wb.ws2 etc. Just ws1, ws2 etc. is sufficient:
Set tb1 = ws1.ListObjects("Totals")
- Thank you! That was driving me crazy!
