Re: Out of stack space problem
Doh, stupid strikes again !
It was because of the Range (..).Select statements, moving to a
different cell and causing a re-invocation of the code. Remove them
and all works fine.
Apologies for the "multiple posts", another network glitch.
Regards
Fred
.
Relevant Pages
- RE: Large file sizes after modifying spreadsheet in Excel 2007.
... than they should be and ultimately causing operations to be very slow. ... My first thoughts were that cell formatting was causing the problem. ... I noticed the borders appear to continue across ...
(microsoft.public.excel.misc) - RE: Large file sizes after modifying spreadsheet in Excel 2007.
... 2GB RAM, running XP Pro SP2. ... than they should be and ultimately causing operations to be very slow. ... My first thoughts were that cell formatting was causing the problem. ...
(microsoft.public.excel.misc) - Re: Question: what is the SAA on the map showing orbital paths?
... >>It's very slowly drifting west - given time it'll become the South ... >What that implies is that the thing causing it is beneath the crust of ... >one wonder what the hell the thing causing it _is_ exactly? ... It's moving because Earth's magnetic field is changing slowly. ...
(sci.space.history) - Re: VBA - Cannot Delete Row with drop down box change
... I had fixed this problem by moving the whole thing to a new workbook. ... there is no error returned because I didn't use the "On Error Goto ... something is pasted to a cell and I assume that changes created by a dropdown ...
(microsoft.public.excel.programming) - Re: Can this be done?
... don't replace the asterisk *. ... Its job is as a wildcard - to be ... "matched" if anything at all is encountered in a cell when moving up ...
(microsoft.public.excel.misc) |
|
