Illegal Operation Program Shutdown!

Sam40mUK · Apr 21st, 2002, 05:16 PM

Hi All,
Big Problem .. of the Mega Variety!
I noticed that the Ranges on an Advanced Filter, extracting to another range were incorrect. These are also incorrect in the macro ..
when I try to change the values I get the following :

EXCEL caused an invalid page fault in
module EXCEL.EXE at 018f:30060a9f.
Registers:
EAX=00000000 CS=018f EIP=30060a9f EFLGS=00010202
EBX=00000000 SS=0197 ESP=0062db30 EBP=0062db70
ECX=c8c51b60 DS=0197 ESI=00dac0fc FS=5157
EDX=0001488f ES=0197 EDI=00000000 GS=0000
Bytes at CS:EIP:
ff 30 ff 74 24 10 e8 52 63 fb ff 50 e8 da 35 fd
Stack dump:
0062db64 00000001 30180e2d 00000000 00000000 0062db64 00000001 00000000 00000201 ab64996d 00000003 00000000 0062fb01 000001ab 00000171 00000000

Am I looking at an 'Excel' problem or a 'System' problem or both?
Any help would be appreciated.
Thanks
S

brettvba · Apr 21st, 2002, 05:37 PM

I would say from past experience that this happens as soon as you have done alot of work and not saved also the fact that excel cannot handle the jandle when it comes to some code!

Sam40mUK · Apr 21st, 2002, 05:43 PM

Morning Brett,
Thanks for the response.
It seems to 'bomb out' when I try to change and run the Advanced Filter' manually without touching the macro code. It definitely does not like it!
I am of a mind to cleardown this sheet and start again in the hope that it will sort it .. but that is for tomorrow.
Cheers
S

Sam40mUK · Apr 22nd, 2002, 01:09 PM

Matter of interest ..
I took the Spreadsheet into work today and changed the Advanced Filter settings and macro in Excel 2002 - No Problem!
I seem to recall writing that aspect of the Spreadsheet in work and hence Excel 2002 but I only have 2000 at home.
Seems a harsh message to receive for using a combination of Excel Versions! I have also encountered problems attempting to operate an AutoSum operation what works in Excel 2000 does not in Excel 2002.
Has anyone else had similar issues between Excel 2002 and 2000?
Regards
S

Jack in the UK · Apr 22nd, 2002, 01:16 PM

without the codes and seeing the prob as you do its hard but dont let anyone tell you CODES are ALL ok some systems OP and Excel version do clase no reason just do..

im working on a passage to help users but im like a hampster on a tread wheel

ROUND AND ROUND..

I suggest record a version_97_whatever
Version_2000_
Version_XP_

and link to what you need.... sounds silly.

I have issues in printing no reasion and even caluclation on loops...

that in win95 and E97 to XP both....

Apr 22nd, 2002, 01:16 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	without the codes and seeing the prob as you do its hard but dont let anyone tell you CODES are ALL ok some systems OP and Excel version do clase no reason just do.. im working on a passage to help users but im like a hampster on a tread wheel ROUND AND ROUND.. I suggest record a version_97_whatever Version_2000_ Version_XP_ and link to what you need.... sounds silly. I have issues in printing no reasion and even caluclation on loops... that in win95 and E97 to XP both.... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 05:16 PM	#1
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Hi All, Big Problem .. of the Mega Variety! I noticed that the Ranges on an Advanced Filter, extracting to another range were incorrect. These are also incorrect in the macro .. when I try to change the values I get the following : EXCEL caused an invalid page fault in module EXCEL.EXE at 018f:30060a9f. Registers: EAX=00000000 CS=018f EIP=30060a9f EFLGS=00010202 EBX=00000000 SS=0197 ESP=0062db30 EBP=0062db70 ECX=c8c51b60 DS=0197 ESI=00dac0fc FS=5157 EDX=0001488f ES=0197 EDI=00000000 GS=0000 Bytes at CS:EIP: ff 30 ff 74 24 10 e8 52 63 fb ff 50 e8 da 35 fd Stack dump: 0062db64 00000001 30180e2d 00000000 00000000 0062db64 00000001 00000000 00000201 ab64996d 00000003 00000000 0062fb01 000001ab 00000171 00000000 Am I looking at an 'Excel' problem or a 'System' problem or both? Any help would be appreciated. Thanks S

Apr 21st, 2002, 05:37 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I would say from past experience that this happens as soon as you have done alot of work and not saved also the fact that excel cannot handle the jandle when it comes to some code!

Apr 21st, 2002, 05:43 PM	#3
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Morning Brett, Thanks for the response. It seems to 'bomb out' when I try to change and run the Advanced Filter' manually without touching the macro code. It definitely does not like it! I am of a mind to cleardown this sheet and start again in the hope that it will sort it .. but that is for tomorrow. Cheers S

Apr 22nd, 2002, 01:09 PM	#4
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Matter of interest .. I took the Spreadsheet into work today and changed the Advanced Filter settings and macro in Excel 2002 - No Problem! I seem to recall writing that aspect of the Spreadsheet in work and hence Excel 2002 but I only have 2000 at home. Seems a harsh message to receive for using a combination of Excel Versions! I have also encountered problems attempting to operate an AutoSum operation what works in Excel 2000 does not in Excel 2002. Has anyone else had similar issues between Excel 2002 and 2000? Regards S