Transfer spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in transfer spreadsheet where to you name the spreadsheet.


I have 4 active datasheets in 1 excel Document

named: Chart, data 2005, data 2004, customers

I just want to import the 2004 data not every sheet
 
See Help on TransferSpreadsheet in VBA Help.

The last argument of the TransferSpreadsheet method is the range. It can be
a specific cell range A1:G200 or it can be a range name, or the name of the
sheet.
 
Back
Top