set range object to named range with non contiguous cells

[OaklandJim]

I am trying to use a named range in a workbook that has non contiguous cells. When I try to set a range object to a named range with contiguous cells the command works. If I try to set the range object to a named range with non contiguous cells Excel chokes. I get an error # 1004 Application-defined or object-defined error. Googling results seem to indicate that I should be able to use VBA with VBA range objects that have non contiguous cells. Is this doable? What should I try?

I have a table with 10 data rows and three "section rows" and I need to process just the 10 data rows that are not contiguous.

 

[HighAndWilder]

I am trying to use a named range in a workbook that has non contiguous cells. When I try to set a range object to a named range with contiguous cells the command works. If I try to set the range object to a named range with non contiguous cells Excel chokes. I get an error # 1004 Application-defined or object-defined error. Googling results seem to indicate that I should be able to use VBA with VBA range objects that have non contiguous cells. Is this doable? What should I try?

I have a table with 10 data rows and three "section rows" and I need to process just the 10 data rows that are not contiguous.

What is in the Refers To box for the named range?

I've tried it and it works fine but we may be doing something different.

 

[OaklandJim]

HighAndWilder​

As often happens I should have known that I was doing something incorrectly and Excel was behaving as advertised. OF COURSE I can define range names with non contiguous cells.

My name definition was screwed up so Excel kept choking on it. I relooked at the RefersTo for the name several times -- pusuant to your question -- and I had not noticed that it was trying to use a name pointing to the wrong worksheet. So the correct worksheet did not even have the range name that I was trying to use.

Lame-assed trubble shooting eh? Thanks for the assist. I apologize for wasting your time.

Low and Tamer (Jim)