-
Solved: someCell.activate and then showing up on screen
Hi,
i'm building a tool thatl loops through each cell in the workbook, but i want a cell that is actually activated to also show up on the screen, so the user sees what cell has just been activated.
i thought that just activating the cell would be enough
[vba]
for each theCell in activeSheet.usedrange.cells
if theCell.value="something" then
theCell.activate
end if
next
[/vba]
but if i do something like this, the cell IS activated, but the user doesnt see anything happening on screen If that cell is not currently visible on the screen.
this means that the user has to scroll down and stuff, instead of the activated cell being brought up for him to see.
is that supposed to happen?
or is there something like
theCell.GetFocus
or have i screwed something up with application.screenupdate=false or something like that

thanx in advance!
Last edited by Koesper; 02-06-2006 at 07:04 AM.
Reason: added some info
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules