Simple macro causing Error7: Out of memory ?

[theta]

Hi All

I have a macro that imports an XML file, removes the namespace from the schema headers

So effectively left with a large table (A1:CC127385)

When I then try to perform some simple actions on this, I get Error 7. When using less data (smaller range) it works fine no problem

Thoughts?

    With oWS
       .UsedRange.Value = oWS.UsedRange.Value 'prevent numbers stored as text
       .Name = "XML Data"
       .Tab.Color = 49407
       .AutoFilterMode = False
       .Cells(1, nLastCol).AutoFilter
       .Range("A2").Select 'for Freeze Panes
    End With
    ActiveWindow.FreezePanes = True

Thanks guys

 

[theta]

Further from last. It fails when it tries to do the .Name element

When I run through on debug mode, the sheet has the first two rows highlighted.

If I manually select A1:CC13000 then I can do paste/special values etc...

Thoughts?