SQL.REQUEST Returns Single Cell
You need to enter this as an array formula. Use ctrl + shift + enter
"Glenn1203" wrote:
I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the
syntax to return all columns in all matching rows?
Thanks for the assistance. Glenn
|