Cyberdude
04-20-2006, 01:19 PM
I have a worksheet that contains 16 charts. When I open the workbook, the part of the sheet that is displayed could be just about anywhere, so I typically scroll right or left to gete to the chart I want to view. At this point either no cell is selected or, if selected, the selected cell is off screen somewhere to the left or right.
My problem is that I want to determine in a macro what columns are currently being viewed. I?ll settle for a range of columns or any one column on the screen being displayed. Is there a statement I can execute that will return the columns (or column) currently being displayed?
Remember that I have no idea where the currently selected cell is, or even IF there is a currently seleced cell. The last thing selected could be a chart or even an autoshape.
My problem is that I want to determine in a macro what columns are currently being viewed. I?ll settle for a range of columns or any one column on the screen being displayed. Is there a statement I can execute that will return the columns (or column) currently being displayed?
Remember that I have no idea where the currently selected cell is, or even IF there is a currently seleced cell. The last thing selected could be a chart or even an autoshape.