Link to home
Start Free TrialLog in
Avatar of mgmhicks
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
Avatar of Norie
Norie

Can we see the rest of the code?
MS Office 2012 ??
Avatar of mgmhicks

ASKER

this doesn't work  sheet1.Cells(5, 2)

but this does work cells(5,2)
ASKER CERTIFIED SOLUTION
Avatar of FarWest
FarWest

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I know right.  I have other worksheets that are just fine.  Here are my references.

User generated image
I think references are fine
can you see sheet1 as this User generated image
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?