I can select non contiguous cells using
with no problem![]()
Range("c2,f2,h2").Select
I can further select to the end of one column data with:
with no problem![]()
Range("c2", [c2].End(xlDown)).Select
however when I try to put these together I using the following:
![]()
Range("c2,f2,h2", [c2,f2,h2].End(xlDown)).Select
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.
Bookmarks