Issue with Union

[jieyi]

This is a working code. The graph can be updated based on this

Please Login or Register  to view this content.

However, my the final cell might change.Hence I use 'Projects' to determine the last filled Cell. To create a range, I use the Union commmand.

Please Login or Register  to view this content.

But when i run this routine, it shows
Error message
Run-time error '1004':
Method 'Range' of object'_Worksheet' failed.

This points to this sentence of my quote

Please Login or Register  to view this content.

anyone have any idea what went wrong????

[Leith Ross]

Hello jieyi,

You have set the object variable "myrange" to the ranges in the Union and that's correct. The problem lies in how you are assigning the range to the chart. You are trying to reference your new range as a named ranged, which it isn't. See below in red...

Please Login or Register  to view this content.

The code should be as below...

Please Login or Register  to view this content.