Selecting Non Contiguous Cell Ranges using a macro

[capnhud]

I can select non contiguous cells using

Please Login or Register  to view this content.

with no problem

I can further select to the end of one column data with:

Please Login or Register  to view this content.

with no problem


however when I try to put these together I using the following:

Please Login or Register  to view this content.

I get the error:

Run-time error '1004':
Method 'Range' of object '_Global' failed

I searched in vba help for what this may mean but no results found.

[shg]

Please Login or Register  to view this content.

[capnhud]

@sht

this results in a compile error

Expected: identifier or bracketed expression

[shg]

Those three dots are where you put in the other range, just as in the first two.

[capnhud]

I had put in like this:

Please Login or Register  to view this content.

and still a compile error

[shg]

Please Login or Register  to view this content.

[capnhud]

I thought I had to duplicate exactly what had been done previously. This works perfectly.