How to add lastCol and lastrow to macro

I am trying to apply lastrow lastcolumn, but not getting it right.

I get the error "The extracted range has a missing or illegal field name"

Thanks

Please Login or Register  to view this content.

Hi, capson,

please add code-tags to your procedure as required per Forum Rule #3.

Untested:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, capson,

in the second example the range is set and VBA recognises that it will refer to Sheet Comments-Tableau.

With the first code you posted the range should refer to Sheet 360-Tableau but if you donīt qualify the cells as part of the range to refer to that sheet as well VBA will assume the cells to be on the active sheeet.

In the code you work with Row 2 for getting the last Column while you want to copy starting in Row 1 - that might be the reason for the error. Make sure that all columns have a header. Or maybe post a sample file to check.

Ciao,
Holger

Hi, capson,

maybe check the values for both your variables before applying them (I tested the code on a sample workbook, and it works okay with my setup: range starting with A1, no empty columns/rows in data range).

Maybe try this:

Please Login or Register  to view this content.

And if it doesnīt work a workbook with a sample of the non working data would be needed.

Ciao,
Holger