View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Annelie[_2_] Annelie[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel to Access using ADO

Little Problem with my macro. Until now a ran a macro which sorted an
prepared the data to be imported to access. In the end range selectio
looked like this:
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
using end right, end down, because the data is not always the same
Actually the columns are always the same, but the rows are not..

How do I translate that to your macro?
Thanks in advance.
Annelie

--
Message posted from http://www.ExcelForum.com