I have macro that needs counts the rows of the filtered table and I have successfully counted the number of rows. I need help with the command or code to insert the rows into a table and I am having an issue because the worksheet has several tables above and below the table I need to add or delete the rows on. 

Below is the code and I get an error stating (Subscript out of range)

TaskTable.ListRows.Add.Range.Value = ActionQuery.ListRows(Number_of_Rows).Range.Value

​I have macro that needs counts the rows of the filtered table and I have successfully counted the number of rows. I need help with the command or code to insert the rows into a table and I am having an issue because the worksheet has several tables above and below the table I need to add or delete the rows on. Below is the code and I get an error stating (Subscript out of range)TaskTable.ListRows.Add.Range.Value = ActionQuery.ListRows(Number_of_Rows).Range.Value  Read More

​