| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting an Excel array
Can someone tell me why this code returns the #value! error
Dim J As Integer, val As Integer, arrnum As Variant arrnum = Evaluate("{=SUMPRODUCT((AGTHistory!A1:A11000=A" & 17 + J & _ ")*(AGTHistory!C1:C11000=Main!B5),AGTHistory!K1:K1 1000)}") Thanks for any help This questions is related to my previous post Worksheets("main").Range("B18:B29").Value = arrnum |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA pasting array into cells | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| pasting array output to sheet | Excel Programming | |||
| Pasting an array into a range | Excel Programming | |||
| Pasting a portion of an array | Excel Programming | |||
Threaded Mode
