Array formula issue

  • Thread starter Thread starter Richard Fletcher
  • Start date Start date
R

Richard Fletcher

I have the following in a macro :-

Range("Y5").Select
Selection.FormulaArray = _
"=SUM(IF(data!$c$2:$c$65000=""Sheffield"",data!
$l$2:$l$65000,0))"

When run it enters this :-

=SUM(IF(data!$C$22481:$C$65000="Sheffield",data!
L22481:L65000,0))

Can someone please tell me what I have to do to stop it
changing the $c$2 to $c$22481, and also explain why it is
doing this???
 
Not much help, I'm afraid.
I copied your code and ran it.
It worked OK. (Excel 2002)
 
Back
Top