Bbcrawford
12-07-2021, 12:26 PM
To overcome the post's limiting of URL references (ie the "AT-Sign") so I've replaced them below with a "Q".
I often insert formulas into ranges using VBA's .Formula ="=..." method. I recently tried inserting a formula into a cell [ ex. .Formula ="=UNIQUE(....)" ] via VBA. The resulting formula inserted in the cell was =QUNIQUE(...) resulting in only the first item in the list appearing. When I manually deleted the "Q" in the cell with the formula it immediately works as expected and showed the full list of results.
Why is this happening and how can I overcome it when inserting a formula this way.
I am using Office 365
Thanks all in advance
Brian
I often insert formulas into ranges using VBA's .Formula ="=..." method. I recently tried inserting a formula into a cell [ ex. .Formula ="=UNIQUE(....)" ] via VBA. The resulting formula inserted in the cell was =QUNIQUE(...) resulting in only the first item in the list appearing. When I manually deleted the "Q" in the cell with the formula it immediately works as expected and showed the full list of results.
Why is this happening and how can I overcome it when inserting a formula this way.
I am using Office 365
Thanks all in advance
Brian