AutoFill 1004 Error

[cicconmr]

This has actually been posted on this site before but was never answered. I'm using 2007 VBE and here is the simpliest two lines of code ever.
Excel has chosen to have them not work and to return an error that:

"AutoFill method of Range class failed"

ThisWorkbook.Worksheets("Portfolio Drop").Range("B2:H2").Select
Selection.AutoFill Destination:=Range("B2:G999")

This is insane....does anyone have any idea what to do? There are no merged cells, by calculations are automatic, and this thing work just 30 minutes ago.

 

[VoG]

Shouldn't it be?

Selection.AutoFill Destination:=Range("B2:H999")

 

[Jonmo1]

You've selected B2:H2
And are filling to B2:G999

should be B2:H999

 

[cicconmr]

Oh Boy......

Thanks