w.Column).Resize(lr).Value = Cells(4, "e").Resize(lr).Value
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Stewart Smith
Sent: Saturday, December 10, 2011 11:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ choose column when running macro
Do
gt; SalesAid Software
> dguille...@gmail.com
> -Original Message- From: trawets
> Sent: Thursday, December 08, 2011 3:02 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ choose column when running macro
>
> Hi
> I have a little macro that copies values from o
ot;f54:f62", "f66:f98")
Rg.Value = 0
Set Rg = ActiveSheet.Range("f102:f187", "f191:f265")
Rg.Value = 0
Set Rg = ActiveSheet.Range("f269:f276")
Rg.Value = 0
End Sub
On 9 December 2011 13:27, dguillett1 wrote:
> Send me your file with a complete explan
Send me your file with a complete explanation (reply to this msg) and
examples.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: trawets
Sent: Friday, December 09, 2011 2:02 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ choose column when
3:02 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ choose column when running macro
>
> Hi
> I have a little macro that copies values from one column to another
> then returns the first column to zero, what I would like to achieve is
> every time I run the macro i
Sent: Thursday, December 08, 2011 3:02 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ choose column when running macro
Hi
I have a little macro that copies values from one column to another
then returns the first column to zero, what I would like to achieve is
every time I run the mac
Hi
I have a little macro that copies values from one column to another
then returns the first column to zero, what I would like to achieve is
every time I run the macro it either asks me which column I wish to
paste value into or auto progresses through the column i.e. B Then C
then E each time in
