View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Hutton[_3_] Spencer Hutton[_3_] is offline
external usenet poster
 
Posts: 17
Default copy a range from another workbook

i want to copy a range ("A:L") in another workbook.
C:\Workbooks\Data.xls

into my active workbook
i do not want the user to see the workbook "data" when it is open. i did
screenupdating = false on the active workbook, but "Data" still gets shown.
i am sure this is a simple statement, but i do not know everything about
VBA.