I have a dataset on a sheet in a different workbook, there are three columns separating the next set of data.
To make a very easy copy/paste, I wanted to use the Usedrange approach.
How does the usedrange know which range of data to use? I have not seen anything in the Help file that indicates this.
Also since I am using variables to qualify the worksheets my syntax is slightly different than the help file examples, and it fails:
[VBA]
Sub Index_Records()
Dim Wsb As Workbook
Dim Wss As Worksheet, Wst As Worksheet
Set Wss = Workbooks("MasterImportSheetWebStore.xls").Worksheets("DataEdited")
Set Wst = Workbooks("TGSItemRecordCreatorMaster.xls").Worksheets("Record Creator")
Wss.UsedRange.Copy Destinaton:=Wst("A1").Paste
End Sub
[/VBA]
thanks,
doug