problem due to migration from Office2k to XP

P

Phil

Should the following line of code cause any problems in ExcelXP.

Sheets("Lookup").Range("H1").FormulaR1C1 = "=Today()"

"Lookup" is a hidden sheet and the code runs automatically when the
file is opened.

It was fine when I was using Excel 2000 now I get the following error

Run-time error '2147417848(80010108)'
Method'FormulaR1C1' of object 'Range' failed

If you select "End"Excel then hangs.

The same code does work on other files but if I copy and paste the same
code from a file that does work it has no effect.

cheers



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error when copying entire row! 5
Search Sheet Names Across Excel Files 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Run-time error ‘-2147417848(8001 2
The object invoked has disconnected from its clients 7
LoadPicture() error XL2007 4
Update cell links between 2 excel file without opening source file 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top