View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
James W.[_2_] James W.[_2_] is offline
external usenet poster
 
Posts: 31
Default 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