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
Hi Jason,
One way to increment your cell is to use the "Cells" thingy.
The "Cells" thingy uses Row, then Column within it's brackets, and it uses
numbers for both - not letters for Columns.
So, Cells(1, 3) refers to Row 1, Column 3, which is the same as Range("C3")
But with the cells thingy,
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