This will copy just the values from the source to the dest. Ranges MUST be
the same size
range(destination).value=range(source).value
This is much better and the same as
range(source).copy
range(dest).paste.pastespecial
Don Guillett
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: Scruffy Huffy
Sent: Wednesday, February 29, 2012 1:41 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
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 <samde...@gmail.com> 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 <tuffhu...@yahoo.com>
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 excel-macros@googlegroups.com
--
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 excel-macros@googlegroups.com
--
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 excel-macros@googlegroups.com