Sent: Thursday, March 01, 2012 2:28 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ indirect function help
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI wrote:
> Dear Selva,
>
> Please see attached sh
;"&A6&"'!g:g"),INDIRECT("'"&"h6"))
>
> > On Feb 29, 5:59 pm, "Asa Rossoff" wrote:
> > > =SUM(INDIRECT("'"&A6&"'!G:G"))
>
> > > -Original Message-----
> > &
;!G:G"))
> >
> >
> >
> >
> >
> >
> >
> > -Original Message-----
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> >
> > On Behalf Of LearnExcel
> > Sent: Wednesday, February 29, 20
quot;))
On Feb 29, 5:59 pm, "Asa Rossoff" wrote:
> =SUM(INDIRECT("'"&A6&"'!G:G"))
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Lea
=SUM(INDIRECT("'"&A6&"'!G:G"))
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LearnExcel
Sent: Wednesday, February 29, 2012 2:34 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ in
Due to spaces in sheet name. I ALWAYS avoid.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: LearnExcel
Sent: Wednesday, February 29, 2012 4:33 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ indirect function help
HI team, can you please help
HI team, can you please help out on the following
I'm using a indirect function but i'm unalbe to get it to work in cell
"A6" if there ia name "sheet2" the forluma works just fine but when
the sheet name is "My Main File" it proivded an REF error is there a
rix for this?
=SUM(INDIRECT(A6&"!G:G
