Dave - thanks for this, I am going to give it a try. StartCellR is a range
where I want to the macro to start entering data based on the formula that
you are helping me with.
Regards
John
On Tue, Apr 27, 2010 at 10:14 PM, Dave Bonallack
<davebonall...@hotmail.com>wrote:
> Hi John,
> What is 'StartCellR'?
> Also, if you paste this formula {=(Sum(AllBLs*(PF=Range(A6).Value)))}
> straight into a cell, you will find that xl won't accept it.
> You can't enter VBA notation into a cell.
> Try:
> "=SUM(AllBLs*(PF=A6))"
>
> Regards - Dave.
>
>
>
>
> > Date: Tue, 27 Apr 2010 13:20:06 -0700
> > Subject: $$Excel-Macros$$ FormulaArray with Named Ranges
> > From: johnw...@gmail.com
>
> > To: excel-macros@googlegroups.com
> >
> > Hi, I have a macro that refuses to run when it reaches the following
> > command:
> >
> > StartCellR.Offset(1, 0).FormulaArray =
> > "=(Sum(AllBLs*(PF=Range(A6).Value)))"
> >
> > AllBLs is a named range
> > PF is a named range
> >
> > I am trying to get excel to sum the values in ALLBLs that correspond
> > to a certain value in PF; that value is defined in Range(A6).
> >
> > Can anyone see what is wrong with my formula?
> >
> > Thanks a lot
> >
> > --
> >
> ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> ------------------------------
> Looking for a hot date? View photos of singles in your
> area!<http://clk.atdmt.com/NMN/go/150855801/direct/01/>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
