I have a piece of code that needs to take action on a cell in one of a many rows in an Excel worksheet. A typical code snippet is:
Most of the time it behaves and selects column 8 in the active row. But occasionally it will go to the last row in the used range.
Does anybody know why - and is there a cure?