Koesper
02-06-2006, 07:02 AM
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
for each theCell in activeSheet.usedrange.cells
if theCell.value="something" then
theCell.activate
end if
next
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
:dunno
thanx in advance!
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
for each theCell in activeSheet.usedrange.cells
if theCell.value="something" then
theCell.activate
end if
next
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
:dunno
thanx in advance!