OaklandJim
Well-known Member
- Joined
- Nov 29, 2018
- Messages
- 863
- Office Version
- 365
- Platform
- Windows
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.
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.