sum a range

B

Brad

I have a program that filters a table and should sum the visible rows in a
particular column and store the results in an array variable. This occurs
inside a for loop. Everything works fine except for the sum part. I'm not
sure what the correct code should be to accomplish this. Here is what I have,
which does not work. Is there a suitable replacement for this?
With workbooks("Data").Sheets("Sheet1").ListObjects("tblData")

iLoop2PrevWeek(iLoopCount) = WorksheetFunction.Sum _
(.ListColumn(4).DataBodyRange.SpecialCells(xlCellTypeVisible))

End with
 
J

Jacob Skaria

Hi Brad, would you be able to provide more information on the structure of
the workbook and the full code.

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a column to a table 4
Dim an array from a filtered Range 1
Creating and transposing a multiarray 3
Need Macro to Sum Range and Paste the Value into one Cell 2
Find Text the Insert Sum 7
Creating a defined name's Refersto range 2
Find Text the Apply a SubTotal Next to Text Address 1
Sum of a Range (with a twist) 6

Top