y, 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 this message: "run-time error '1004': Method
> 'Range' of object'_Global' fai
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 th
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 this....anything obvious I'
; > > missing?
> >
> > > Thanks.
> >
> > > Robb
> >
> > > On Feb 29, 4:55 pm, "dguillett1" wrote:
> > > > range("a2:z223").copy
> > > > range("a1").paste pastevalues
> >
> > > > Do
ing?
>
> > Thanks.
>
> > Robb
>
> > On Feb 29, 4:55 pm, "dguillett1" wrote:
> > > range("a2:z223").copy
> > > range("a1").paste pastevalues
>
> > > Don Guillett
> > > SalesAid Software
> > > dguille
t;
> On Feb 29, 4:55 pm, "dguillett1" wrote:
> > range("a2:z223").copy
> > range("a1").paste pastevalues
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> >
> >
> >
> &g
t1" wrote:
> 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
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&
opy
> 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:
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 wrote:
> SH, I'd suggest you try recording macro and after you perform the copy
> paste special as values, c
-
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 g
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 wrote:
> Sam,
>
> I've already tried thatbut it doesn't remove the animation around
> the
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
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 wrote:
> This
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 co
15 matches
Mail list logo
