Ok, thanks Paul.
Dave.
Date: Tue, 9 Feb 2010 20:11:23 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ excel vba help
To: excel-macros@googlegroups.com
Sometimes, Cells() is a bit easier to read.
For instance, if you want to cycle through columns A-J
and rows 1-100
and
Cells() can do that isn't available in Range()
But usually, I just use the one that fits my code.
P
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Tue, February 9, 2010 9:38:46 PM
Subject: RE: $$Excel-Macros$$ excel vba help
Thanks P
Thanks Paul,
Always learning.
BTW, does 'Cells' do anything that 'Range' can't?
Dave.
Date: Tue, 9 Feb 2010 05:58:28 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ excel vba help
To: excel-macros@googlegroups.com
Dave...
Just a bit of
but still...
Paul
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, February 8, 2010 9:52:17 PM
Subject: RE: $$Excel-Macros$$ excel vba help
Hi Jason,
One way to increment your cell is to use the "Cells" thingy.
Th
(i, 1) will refer to A3, and so on.
Hope this helps.
Regards - Dave.
> Date: Sun, 7 Feb 2010 13:54:22 -0800
> From: opie...@yahoo.com
> Subject: $$Excel-Macros$$ excel vba help
> To: excel-macros@googlegroups.com
>
> I am trying to teach myself how to use the vba.
Dear Jason,
To do this you do not need the macros
Go to edit-> Fill-> Down
That will work
Sanjoy
On Mon, Feb 8, 2010 at 3:24 AM, jason nix wrote:
> I am trying to teach myself how to use the vba. I want to use a copy/paste
> and loop macro for some equations. I already know how to use my f
I am trying to teach myself how to use the vba. I want to use a copy/paste and
loop macro for some equations. I already know how to use my formulas to
automatically calculate but I need help getting info into the right cell. The
basics of it goes like this; I want to get a number to copy to the
