simonjervis
New Member
- Joined
- Jun 4, 2009
- Messages
- 18
In column D I have a formula which will result in only one cell returning an error. I have the following code which is selecting that cell;
Range("D19:D6588").Select
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
I would now like the code to scroll to that cell, but am having trouble achieving this. I tried addind the following;
Application.Goto Selection = ActiveCell, Scroll:=True
But of course this doesn't work becuase the cell I want to scroll to is SELECTED not ACTIVATED.
Can anyone help?
Range("D19:D6588").Select
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
I would now like the code to scroll to that cell, but am having trouble achieving this. I tried addind the following;
Application.Goto Selection = ActiveCell, Scroll:=True
But of course this doesn't work becuase the cell I want to scroll to is SELECTED not ACTIVATED.
Can anyone help?
Last edited: