*Simple...*
On Fri, Feb 17, 2012 at 7:19 PM, Rajan_Verma wrote:
> Why VBA?
>
> Select the data
>
> Press Shift+Ctrl+F3
>
> And Choose Top Row and Ok
>
> ** **
>
>
>
> ** **
>
> Regards
>
> Rajan.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1
riday, February 17, 2012 11:35 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Creating and naming multiple ranges
I thought about the suggestion you made before but I didn't want to
have to name each range one-by-one. It looks like i would have to.
On Feb 17, 11:59 am, "dgu
q3
> '=OFFSET(A1,2,MATCH("scheduled interest",1:1,0)-1)
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Matt
> Sent: Friday, February 17, 2012 10:40 AM
>
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Ex
of mine to find aq3
> '=OFFSET(A1,2,MATCH("scheduled interest",1:1,0)-1)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 10:40 AM
> To: MS EXCE
012 10:40 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Creating and naming multiple ranges
Well, I wanted to loop through each column in this sheet and name it
as a range based on the first cell of each column, so that I can refer
back to a particular range with some formulas on the
gt;
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 9:26 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Creating and naming multiple ranges
>
> Hi Don, why do you believe this is a bad idea? I'm just curi
, February 17, 2012 9:26 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Creating and naming multiple ranges
Hi Don, why do you believe this is a bad idea? I'm just curious.
any ideas as to how else to go about this task?
On Feb 17, 10:11 am, "dguillett1" wrote:
I REALLY
Hi Don, why do you believe this is a bad idea? I'm just curious.
any ideas as to how else to go about this task?
On Feb 17, 10:11 am, "dguillett1" wrote:
> I REALLY think this is a BAD idea in that there are other and BETTER ways to
> do this without cluttering your project with a bunch of names
I REALLY think this is a BAD idea in that there are other and BETTER ways to
do this without cluttering your project with a bunch of names . But, if you
insist.
Sub namecolumns()
dim I as long
For i = 1 To Cells(1, Columns.Count).End(xlToLeft).Column
Cells(1, i).Resize(Cells(Rows.Count, i).End(
