How can I deselect a range?

T

TomThumb

During some operations, Excel deselects (or UnSelects) a range. How can I do
this deliberately?
 
C

CyberTaz

There must be more to the issue than your description indicates -
"deselecting" a selected range should require nothing more than clicking any
cell or pressing one of the arrow keys to move the cell selector. (Whereas
Tab & Return/Enter allow you to navigate within the range without
deselecting it. BTW - holding Shift with those keys reverses direction.)

It's also not clear as to what "operations" you mean, so that piece of
"non-information" actually muddies the waters instead of clarifying them :)

If this isn't sufficient please post back with a more complete & accurate
description of what is/isn't happening... Nobody here can see over your
shoulder so the only way we can visualize what's going on is by way of the
description you provide is your post. Also, always specify what version of
the program & OS you're using.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
T

TomThumb

I am using Excel 2007 VBA, and wish to deselect a selected cell in a
spreadsheet programmatically. Excel can do this and I need to know how.
 
B

Bob Greenblatt

Well that little bit of information makes a few big differences - most
significant of which is that this forum is for Mac Excel. Perhaps one of the
VBA coders might have something to offer here, but in the meantime the
following link should point you in the right direction:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Good Luck |:>)
Bob Jones
[MVP] Office:Mac
Click to expand...
It is not possible to have "nothing" selected. You can certainly change the
selection, or select an object instead of a cell, but you can't deselect.
You could simulate this by selecting a cell out of view or some object that
is hidden. However, You'll probably have trouble with the user doing
something unintentional to the selected thing.
 
K

kdsdata

With apologies for posting here, as my comment applies to FrontPage, but is
for a similar situation.

With a macro I am modifying a "selection" of cells that were selected
programmatically. I now need to find a way to "unselect" the cells,
otherwise my cursor move doesn't work (not a legal operation). As long as
the cells stay selected FrontPage stays in a table "design" display mode
(blue bordered cells, with handles) that doesn't allow the cursor move
command such as SendKeys "{DOWN}".

Would be good to be able to set the selection to say "nothing", like for
variables, databases, recordsets, etc.

Fritz Kiessling
kdsdata
 
B

Bob Greenblatt

With apologies for posting here, as my comment applies to FrontPage, but is
for a similar situation.

With a macro I am modifying a "selection" of cells that were selected
programmatically. I now need to find a way to "unselect" the cells,
otherwise my cursor move doesn't work (not a legal operation). As long as
the cells stay selected FrontPage stays in a table "design" display mode
(blue bordered cells, with handles) that doesn't allow the cursor move
command such as SendKeys "{DOWN}".

Would be good to be able to set the selection to say "nothing", like for
variables, databases, recordsets, etc.

Fritz Kiessling
kdsdata
Click to expand...
Well, yes, it might be nice to set the selection to nothing. But, you just
can't in Excel. As a prior poster told you, you are in a macintosh forum.
Now, particularly since the problem is related to Front Page, you will
probably receive better advice from a windows forum.
 
Top