Loading...

excel-macros@googlegroups.com

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied Sam Mathai Chacko Wed Feb 29 12:01:16 2012

SH, I'd suggest you try recording macro and after you perform the copy
paste special as values, check the macro, you should find how to write the
code.

Sam

On Thu, Mar 1, 2012 at 1:11 AM, Scruffy Huffy <[EMAIL PROTECTED]> wrote:

> Sam,
>
> I've already tried that....but it doesn't remove the animation around
> the cell that I copied from.  I guess I really need a "double-click"
> option, rather than just a "select" option.  I could select fifty
> different cells in succession, and still not remove the original
> animated cursors.
>
> Also (since you're being so helpful), any ideas on how to paste JUST
> the value of cell?  I'm sure there's a "paste special" action that I'm
> missing somewhere, but I'm not having great success.  (This is
> necessary because I need four separate options copied and pasted as
> static totals:  One formula performs the calculations for each option,
> but the total can't be "live linked" to each option).
>
> Thanks for your time.
>
> Robb
>
>
>
> On Feb 29, 1:52 pm, Sam Mathai Chacko <[EMAIL PROTECTED]> wrote:
> > The trick is to select another cell... at any given time, at least one
> cell
> > WILL be selected (if not any other object) in a sheet. So at the end of
> > your macro, select any other cell, for example the top left cell A1
> >
> > Sam Mathai Chacko
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy <[EMAIL PROTECTED]>
> wrote:
> > > This problem is a bit difficult to describe, but here goes.   I'm
> > > using a command button macro to select a cell, copy its value, then
> > > past the value to another cell.
> >
> > > However, I don't know the code to "de-select" the copied cell.  In
> > > other words, after the copy/paste is complete, the cell that I copied
> > > from is still highlighted (has the animated "ant trails") going around
> > > it.
> >
> > > I'm sure there's a simple solution.   Thanks in advance for your help!
> >
> > > Robb
> >
> > > --
> > > FORUM RULES (986+ members already BANNED for violation)
> >
> > > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> > > will not get quick attention or may not be answered.
> >
> > > 2) Don't post a question in the thread of another member.
> >
> > > 3) Don't post questions regarding breaking or bypassing any security
> > > measure.
> >
> > > 4) Acknowledge the responses you receive, good or bad.
> >
> > > 5)  Cross-promotion of, or links to, forums competitive to this forum
> in
> > > signatures are prohibited.
> >
> > > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > > owners and members are not responsible for any loss.
> >
> > >
> ---------------------------------------------------------------------------
> ---------------------------
> > > To post to this group, send email to [EMAIL PROTECTED]
> >
> > --
> > Sam Mathai Chacko
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to [EMAIL PROTECTED]
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to [EMAIL PROTECTED]