I am in process of developing complex model in excel.
It has 4 tables[Table A, B,C, D] where user has to go in and make different selections. At the moment, it invloves quite a bit of scrolling from one table to next. I have attached the file which has a snapshot of the model showing different tables.
I ended up writing something which selects the cells and not puts them on screen. Can some one share code for displaying/viewing a range of cells.
Any insight will be much appreciated