Hi all!

I have been trying to find all occurances of a value in a 14,000+ row table. I finally found this pice of code:

'=IF(COUNTIF(INDEX(tbl,0,1),G$1)>ROW()-ROW(H$1),OFFSET(tbl,SMALL(IF(INDEX(tbl,0,1)=G$1,ROW(tbl)-CELL("Row",tbl)),ROW()-ROW(H$1)+1),1,1,1),"")
It works excellently well, but needs to be entered directly into a cell as an array (CTRL + SHIFT + ENTER). When I try to assign this value to a cell using VBA, the "Row" seems to be causing an issue since it uses the dbl quotes.

Can anyone shed a little light on how I might be able to get VBA to accept this?

Many thanks in advance!!!