Trying to use .Range(Cells(x,x),Cells(x,x)).Copy with no success

[rcarneiro]

Hi guys,

Can anyone help me?

I'm trying to make this code copy a range to clipboard and than paste it as .PasteEspecial but i'm geting an error.

Error: 1004
Application-defined or Object-defined error

Heres the code:

Please Login or Register  to view this content.

Thank you guys.

[ELeGault]

If I am not mistaken you need to SET the ranges CabCol and CabLin, which is likely causing that error or this issue

Please Login or Register  to view this content.

[Arkadi]

Can you attach a workbook? is the spelling of the workbook and sheetname right? also have you checked the values of CabLin and CabCol when the error happens?

[ELeGault]

If I am not mistaken you need to SET the ranges CabCol and CabLin, which is likely causing that error or this issue

Please Login or Register  to view this content.

Really any Defined Range... and it is good habit to also set to Nothing at the end of your run

Please Login or Register  to view this content.

[Arkadi]

If I am not mistaken you need to SET the ranges CabCol and CabLin, which is likely causing that error or this issue

Please Login or Register  to view this content.

CabLin and CabCol are numeric values I believe... that get their value from those ranges. I think they are just a variable for row and column, not actual Ranges.

[StephenR]

You need to fully qualify all your range and cells references with workbook and sheet.

[rcarneiro]

CabLin and CabCol are numeric values I believe... that get their value from those ranges. I think they are just a variable for row and column, not actual Ranges.

Yes, they are numeric values, going from 1 to 20 maximun, CabCol is the numeric value of the column i want to set and CabLin is the numeric value of the row.

[buran]

@ELeGault: that's not the case. Obviously CabCol and CabLin are column and row number, not range object. Evident also from the way it is used later in the code.

@rcarneiro: do you have "Divisor 2.0.xlsm" already open? also are you certain you have numbers in B2 and B4?

[rcarneiro]

@ELeGault: that's not the case. Obviously CabCol and CabLin are column and row number, not range object. Evident also from the way it is used later in the code.

@rcarneiro: do you have "Divisor 2.0.xlsm" already open? also are you certain you have numbers in B2 and B4?

Yes, the whole code just copies from worksheet (2) the matching criteria filtered and then copy to another created worksheet (ws.destino).

I'll make sure is Divisor 2.0 which is open in the moment.

Edit. Yes, Divisor 2.0 is open and active when i'm trying to Copy the Range, but it gives me the error anyways.

[rcarneiro]

The thing is:

I was using it like this:

Please Login or Register  to view this content.

And it was all fine.

But then I need to make the columns dynamic, thats why I used Cells inside .Range and now I get the error.

Anyone know anything about the .Range(Cells(x,x),Cells(x,x)) and why it is giving me an error?

Thanks

[shg]

Cells refers to the active worksheet unless qualified.

Please Login or Register  to view this content.

You need the dot in front of Range if you use a literal range string:

Please Login or Register  to view this content.