mgmhicks
asked on
How to return reference to sheet1 in excel
This spreadsheet was updated from MS Office 2012 to MS Office 2013. Now code I used before sheet1.cells(5,2) comes back and tell me application-defined or object defined error. So somewhere I lost a reference. could someone please tell me how to get It back. I cant seem to use sheet2.activate or anything referencing the sheets.
thanks
thanks
Can we see the rest of the code?
MS Office 2012 ??
ASKER
this doesn't work sheet1.Cells(5, 2)
but this does work cells(5,2)
but this does work cells(5,2)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I do. it does the same for other sheets within the same workbook.
Will you send me the file. You can remove any data inside but keep the sheets. And make sure that the problem still exists in the uploaded file
BTW did the code I gave you before solved the problem?
BTW did the code I gave you before solved the problem?