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
Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 8:50 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Creating and naming multiple ranges
>
> Hello, I have a spreadshe
(xlUp).Row).Name = Cells(1, i)
Next i
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Matt
Sent: Friday, February 17, 2012 8:50 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Creating and naming multiple ranges
Hello, I have a spreadsheet
Hello, I have a spreadsheet and It has many columns and I want to
create a range for each column automatically and name it based on the
value at the top row. Unfortunately, this code i created doesn't work.
Can anyone help me fix this code?
Any help would be great!
Sub test()
Dim icol As Intege
