Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Scruffy Huffy
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Sam Mathai Chacko
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Scruffy Huffy
- 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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Sam Mathai Chacko
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Kris
: 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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread dguillett1
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-03-01 Thread Scruffy Huffy
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

$$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread Scruffy Huffy
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread Sam Mathai Chacko
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread 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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread Sam Mathai Chacko
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread dguillett1
- 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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread Scruffy Huffy
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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread Scruffy Huffy
).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

Re: $$Excel-Macros$$ Un-selecting a cell being copied

2012-02-29 Thread dguillett1
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