>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Scruffy Huffy
> *Sent:* Saturday, March 17, 2012 6:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ An EASY One: I Need a formula that checks
Perfect...Thanks much!
On Saturday, March 17, 2012 8:16:33 AM UTC-4, Rajan_Verma wrote:
>
> =IFERROR(MATCH(E6,G6:G12,0)>0,FALSE)
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Scruffy Huffy
> *Sent:* Mar/Sat/2012
Hello!
I'm positive I'm overlooking the simple solution, but I need a formula that
returns a "true/false" "yes/no" value (or something like that) after
checking if a cell's value is contained in a given list. In other words,
"Q: Is Cell A ("Widget") contained in list B "Stock Items"? A: Ye
I just sent itThanks!
On Mar 1, 9:42 am, "dguillett1" wrote:
> Reply to my email with your file
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Scruffy Huffy
> Sent: Thursda
uot;).resize(range("a2:z223").rows.count,range("a2:z223").columns.cou
> nt)
> .unmerge
> .paste pastevalues
> end with
>
> Regards,
> Sam Mathai Chacko
>
>
>
>
>
>
>
>
>
> On Thu, Mar 1, 2012 at 6:21 PM, Scruffy Huffy
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
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:
py
> 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 remo
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, Sc
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
10 matches
Mail list logo
