Setting Ranges With Union Method

Hi All

Tried to write a Macro to Range Cells in a sheet, setting the range values from a another cell.
I have encounted a Run-Time error as select method of Range class failed.
Below is the Macro.

Please Login or Register  to view this content.

Have the Ranges been set incorrectly?

Preston

Please Login or Register  to view this content.

Charlize