View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Extract MS Query Cell Address

The querry Name and Range becomes a defined Name on the worksheet. You can
view the range on the worksheet by going to menu and doing the following

File - Properties - Contents


Use this VBA code to see all names including querry name

For Each myname In ThisWorkbook.Names
MsgBox (myname.Name & " Range is : " & myname)
Next myname:

When I Import Data (MS Query) into my spreadsheet is asks for destination
cell. Is it possible to extract this cell address from the MS Query object
after-the-fact?

Thanks
EM