MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

unselect all selected cells?

  Asked By: Darcy    Date: Jan 14    Category: MS Office    Views: 2507

Excel 2003
Win XP

I frequently 'select' or 'activate' cells when working in VBA in order
to designate a reference location. Then I use the 'offset' command to
reference other cells. (This is probably a bad way to do things.) I
often want to unselect all cells.

Is it possible to unselect all selected cells with VBA code?



2 Answers Found

Answer #1    Answered By: Adelmo Fischer     Answered On: Jan 14

At least one cell must be select. Maybe you should select  one that isn't
useful for your code. Why not use range instead select or activate?

Answer #2    Answered By: Mansur Bashara     Answered On: Jan 14

I don't see a way to do this. Try activating another worksheet and
then coming back to your original, but if you really need to do this,
it's better to never select  anything in the first place.

Didn't find what you were looking for? Find more on unselect all selected cells? Or get search suggestion and latest updates.