Unable to select individual cells when in vba break mode

[davidam]

Hello All,
While constructing a procedure, I use 'Stop' in order to break execution and then step through subsequent lines in the program. Sometimes when I do this, the worksheet seems to anchor on one cell such that if I select another cell then an array, cornered by the original cell and the newly selected cell, will be selected. Has anyone else seen this? Any ideas on what causes it? When I type a different cell address in the cell address bar it returns to normal.
Thanks,
David

 

[Norie]

David

This behavior could be connected to the code you are running, can you post the code?

 

[davidam]

Hi Norie,
The program is pretty big and I am not sure where I was when I last saw the behaviour. I can say without any doubt, however, that the code did not call for any selecting. (I have been well schooled on the folly of unnecessarily selecting ranges by this forum!).

 

[Norie]

Why are you selecting cells when code execution has been interrupted?

 

[Rick Rothstein]

Why are you selecting cells when code execution has been interrupted?

That is the question I was just about to post.

 

[davidam]

The code is acting on different parts of the sheet and I want to move around so that I can see what is happening...I know I could do this programically but it is quicker just to do it myself sometimes.

 

[Norie]

If you want to move around the sheet use the scroll bars.

 

[davidam]

I looked through the code and found one place where the code selected the 'anchor' cell. I wonder if VBA treats a cell selection like a shift-select, rather than just a select. If so it would account for this behavior, because a normal selection would be released as soon as another cell is selected.

 

[Rick Rothstein]

I looked through the code and found one place where the code selected the 'anchor' cell. I wonder if VBA treats a cell selection like a shift-select, rather than just a select. If so it would account for this behavior, because a normal selection would be released as soon as another cell is selected.

No, that is not how it works in VBA. If you did something like this in code, you could create the effect you are seeing though...

' Select the anchor cell
Range("C5").Select
...
...  {later on in your code}
...
' Assuming H9 is a new cell to be selected
Range(Selection, Range("H9")).Select

Of course, without being able to see your actual code, all we can do is guess here.

 

[davidam]

I think it is a bug, not the code. It happens occasionally and it is an annoyance more than anything. If I type a new cell address in the name bar, it stops doing it. Just wondered if others had seen it.