NewDaddy
02-14-2008, 08:27 AM
Hi All
I am looping through excel workbooks (monthly transaction reports) in a folder, extracting data based on certain criteria (using the autofilter) and using the currentregion property copying that data to my main workbook so I end up with transactions for all months that meet the criteria in 1 worksheet. (see extract below)
Cells.CurrentRegion.Copy Destination:=aBook.Range("A1").Offset(x, 0)
x = aBook.UsedRange.Rows.Count
What I would like help with is 'adjusting' the currentregion so I am not copying row1 of the current region (i.e. the title row), but from row 2 down, how can I do this?
Thanks
I am looping through excel workbooks (monthly transaction reports) in a folder, extracting data based on certain criteria (using the autofilter) and using the currentregion property copying that data to my main workbook so I end up with transactions for all months that meet the criteria in 1 worksheet. (see extract below)
Cells.CurrentRegion.Copy Destination:=aBook.Range("A1").Offset(x, 0)
x = aBook.UsedRange.Rows.Count
What I would like help with is 'adjusting' the currentregion so I am not copying row1 of the current region (i.e. the title row), but from row 2 down, how can I do this?
Thanks