Run-time error 1004 Application-defined or object-defined error

[VAer]

Please Login or Register  to view this content.

The button is in sheet Dashboard, when I click the button and it returns the error.

What does it mean and how to fix it?

Thanks.

[bsalv]

https://stackoverflow.com/questions/...1%20characters.

apparently, there could be a cell with a very long string in it ???
What happens if you do it in 2 steps?

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[Artik]

You can reference a Range object in several ways. One is referencing starting and ending cells by reference. Your Range object is a certain range in the Temp worksheet. Since the Dashboard sheet is active at this point, using the code

Please Login or Register  to view this content.

it tried to create a Range object on the Temp sheet, but from cells in the Dashboard sheet (or active sheet). This is obviously impossible, and that's why you were getting an error. The actual range reference would be the code:

Please Login or Register  to view this content.

, but it is very long and inconvenient. Therefore, the construction With ... End With is used, as jindon has shown. Note the dots in front of Cells, they will make the range's start and end cells reference the Temp sheet.
Another way to refer to Range is by addressing. The following code will be correct, even though Cells points to cells in the active worksheet. But we only get the address.

Please Login or Register  to view this content.

Since the start and end cells are constant, it will be more readable to use addresses this way:

Please Login or Register  to view this content.

Artik