Hi All
I think this will be a simple one, basically I have a code that checks some stuff, and I would like it to stop when it finds a problem with the data and select the cell so the user can do stuff.
Range.Select works, the cell is selected, however if its way down the rows it wont show, the user still has to scroll down and find the selected cell, is there another command to add in so the screen also goes to the cell so that its immediately visible to the human eye?
Thanks in advance.