$$Excel-Macros$$ worksheetfunction.counta not returning correct value

2013-02-15 Thread amitjha2487
Hello everyone, what i am trying to do is iterate through a range containing worksheet names and if the cell is not empty then add the result of CountA function to the count variable. So the count variable should be equal to number of non lank cells in range B9:B28 on the worksheets I'm

Re: $$Excel-Macros$$ worksheetfunction.counta not returning correct value

2013-02-15 Thread David Grugeon
Try (c.value :!b9:b28) On Saturday, 16 February 2013, amitjha2487 wrote: Hello everyone, what i am trying to do is iterate through a range containing worksheet names and if the cell is not empty then add the result of CountA function to the count variable. So the count variable should be

Re: $$Excel-Macros$$ worksheetfunction.counta not returning correct value

2013-02-15 Thread Amit Kumar Jha
Thanks a ton David, finally got it working.. On Sat, Feb 16, 2013 at 3:42 AM, David Grugeon da...@grugeon.com.au wrote: Try (c.value :!b9:b28) On Saturday, 16 February 2013, amitjha2487 wrote: Hello everyone, what i am trying to do is iterate through a range containing worksheet names