Thread: In code using usedrange Error message 1004 Out of stack space?

I have a simple worksheet that doesn't contain alot (for now) only some headlines in the cells: A2,B2,C2

I have written a code string in Office 2007 which writes the used range address of of the sheet to the cell A1, but when I open the workbook in Excel 97 the codestring doesn't seem to work i just get the following error message:

Run-time error '1004:

Out of stack space


The code string is as follows:

Sheets("Sheet1").Cells(1, 1) = Sheets("Sheet1").UsedRange.Address

Can this be fixed?

Or is there an alternative to the Usedrange.Addres code?

Please help.

/Freakazoid