View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glenn1203 Glenn1203 is offline
external usenet poster
 
Posts: 5
Default Paste into a QueryTable

I would like to form a SQL query that would Select Where a column value
equals a value in cell A1. I'm trying to write a macro that will copy the
value from the cell and paste it into a Database Query QueryTable box. Is
there an easier way to do this? Can I paste into a QueryBox?

Help is much appreciated. Glenn