software

Hi,

how to (by VBA macro code) unselect all selected cells/areas in all
sheets named for example quot;MyPage Xquot;, where X is an ascending number
from 1 and up?

BR,
Siri--
SiriS
------------------------------------------------------------------------
SiriS's Profile: www.excelforum.com/member.php...foamp;userid=7995
View this thread: www.excelforum.com/showthread...hreadid=502832Something has to be selected in each sheet--either a range or an object.

So you could just select a different cell????

SiriS wrote:
gt;
gt; Hi,
gt;
gt; how to (by VBA macro code) unselect all selected cells/areas in all
gt; sheets named for example quot;MyPage Xquot;, where X is an ascending number
gt; from 1 and up?
gt;
gt; BR,
gt; Siri
gt;
gt; --
gt; SiriS
gt; ------------------------------------------------------------------------
gt; SiriS's Profile: www.excelforum.com/member.php...foamp;userid=7995
gt; View this thread: www.excelforum.com/showthread...hreadid=502832

--

Dave Peterson


OK, of course, at least one cell has to be selected in a sheet.. Sorry
to bother you all with this problem!

My problem was that I am looping through a lot of sheets and for all
selected columns in the sheets I do some calculations and then create a
new sheet with the result. Before I select all columns I will do the
calculations for I need to quot;unselectquot; everything else.

But it will work fine by first just selecting, say cell quot;B2quot;, in all
sheets, just as you told me, and then select the other columns.

And during the calculations I will check that selection is not quot;B2quot;.

Thanks,

Siri--
SiriS
------------------------------------------------------------------------
SiriS's Profile: www.excelforum.com/member.php...foamp;userid=7995
View this thread: www.excelforum.com/showthread...hreadid=502832