selecting a table with variable rows and columns

[prjames3]

I’m trying to select all data in a table to move to another sheet, but the table will change every day so I need the selection to change with the table. I’ve used end(xlUp) often to find the bottom row, but I’m not sure how to combine that with a variable column number.

I keep getting an “Object required” error message.

Please Login or Register  to view this content.

Thanks for any help.

[AlphaFrog]

ActiveWorksheet is not a VBA key word. Use ActiveSheet or nothing

ActiveSheet.Range(Cells(9, 1), Cells(lastrow_source, lastColumn)).Select

Or

Range(Cells(9, 1), Cells(lastrow_source, lastColumn)).Select