| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 40036
Paul
Post the code. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Paul" wrote in message ... Hi- I wrote a macro that includes a line of code that select a sheet in the format Sheets("Sheetname").select. It worked fine for a few weeks but all of a sudden VB started breaking on that line of code with the run-time error 40036 message "Application defined or object defined error". The sheet has not been renamed and is still present. Is this a bug or can it be fixed? Thanks, Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
| Receiving run-time error only part of the time | Excel Discussion (Misc queries) | |||
| run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
Linear Mode
