LinkBack URL
About LinkBacks
zinzah 
One of several methods is to simply double up your quotes...
Range("A1").FormulaArray = "=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),"""")"
One of several methods is to simply double up your quotes...
Range("A1").FormulaArray = "=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),"""")"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks