pastevalues
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Scruffy Huffy
Sent: Wednesday, February 29, 2012 3:51 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
Thanks for the suggestion
Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Scruffy Huffy
Sent: Wednesday, February 29, 2012 3:51 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
Thanks for the suggestion. Any
-
From: Scruffy Huffy
Sent: Wednesday, February 29, 2012 3:51 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
Thanks for the suggestion. Any ideas on what to do when the source
and destination are merged cells of different
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
Thanks for the suggestion. Any ideas on what to do when the source
and destination are merged cells of different sizes?
Right now, I'm copying the source value to a random cell in the
workbook
: Wednesday, February 29, 2012 3:51 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
Thanks for the suggestion. Any ideas on what to do when the source
and destination are merged cells of different sizes?
Right now, I'm
Reply to my email with your file
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Scruffy Huffy
Sent: Thursday, March 01, 2012 6:51 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
I did this and got
MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don,
I did this and got this message: run-time error '1004': Method
'Range' of object'_Global' failed
I'm definitely a novice when it comes to thisanything obvious I'm
missing?
Thanks.
Robb
On Feb 29, 4:55 pm
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
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
Sam,
I've already tried thatbut 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
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 tuffhu...@yahoo.com wrote:
Sam,
I've already tried thatbut it doesn't remove the
-
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 thatbut it doesn't remove the animation around
the cell that I copied from. I guess I really need a double
Sam,
That was very helpfulI was missing the code line
Application.CutCopyMode = False.
That took care of the ant trail.
Thanks Again!
Robb
On Feb 29, 2:46 pm, Sam Mathai Chacko samde...@gmail.com wrote:
SH, I'd suggest you try recording macro and after you perform the copy
paste special
).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
range(a2:z223).copy
range(a1).paste pastevalues
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Scruffy Huffy
Sent: Wednesday, February 29, 2012 3:51 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Un-selecting a cell being copied
Don
15 matches
Mail list logo