Run Time Error 1004: Method Range of Object _Global Failed

[mkc80]

Hello,

I am trying to run reports in Access 2007 Database (output is an Excel file) one after the other.
The first report works perfectly, but when I try to run the second report, I get the error
"Run Time Error 1004: Method Range of Object _Global Failed"

(Both of these reports are same except the first report is for 1Month Sales and Second Report is for 6 Months).

I have to close and re-open the database every time I need to run these reports one after the other.

Here is the code:

'Rearrange Columns


.Range("E:F").Select
.Selection.Cut
.Range("M:N").Select
.ActiveSheet.Paste
.Range("G:N").Select
.Selection.Cut Destination:=Range("E:L") (This is where code fails when the second report is run with the above error message)

I have googled the error but couldn't find a satisfactory answer...

[John_G]

Not too familiar with Excel VBA yet, but should Range("E:L") not have a period before it, as all your other .Range .... do, i.e. .Range("E:L") ?

John