I’m trying to select a range of cells in a drawing BOM table so that the user can see what is selected. It looks like the SetCellRange might be the solution, but It’s not working for me.
The linked example tells how to get information about what’s already been selected by the user, not how to select ranges of cells programmatically.
How is it “not working for you”? Please help us help you by posting a MRE.
I’m not sure what an “MRE” means but I’m not seeing any change on the screen. Whatever cells were already selected when my macro runs remains selected after I do whatever manipulation I am doing to the table and after I try using the SetCellRange method. It’s not just a visual thing because if I run the macro immediately afterwards, the selection set is indeed still the original selection set and not what I had tried to select using SetCellRange.
Minimum reproducible example. Make the simplest runnable (not necessarily functional, but runnable) sub or function demonstrating how you are trying to use it. Possibly even with an example file. It’s possible that we may be able to pinpoint what’s not working just by reading your code, but if not we at least have a starting point instead of completely writing you something from scratch.