| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change worksheets through code
I have an excel program that uses code to retrieve values from on sheet for
use in a function or sub. The code worked fine but has stoped. This code snippit Sheets(REPORTSHEET).Activate sCE = ActiveSheet.Cells(CER, CEC).Value Worked fine but now I find that the reports sheet is not being activated if the user is on a different sheet when he calls the sub or function. (CER and CEC are defined as constants to make it easy to change the layout of a report). One possible problem could be that part of the program was developed on Office 2003 and part was developed on Office 2000. I can use all the help I can get on this one it has been driving me crazy a short trip but not much fun. Thanks Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine Worksheets - help with Code! | Excel Discussion (Misc queries) | |||
| Adding code to worksheets | Excel Programming | |||
| Change code to make worksheets instead of workbooks | Excel Programming | |||
| Need code to protect worksheets - amount of worksheets varies | Excel Programming | |||
Threaded Mode
