Puzzling Memory Error !
I have a macro that runs fine if I open the visual basic editor and
run from there, but if I use the run button on the excel visual basic toolbar it results in a memory error (could not be written) in exactly the same place every time. Why should it be doing this ! If it helps anybody, The macro generates a large number of commandbuttons on a number of sheets at specified places. I can't understand why it will run OK from the visual basic editor but not from excel itself. Can anybody shed any light to this ? Cheers Donna |
Puzzling Memory Error !
Not without seeing your code! Sounds like something real simple.
-- | +--Thief_ | "Donna" wrote in message om... I have a macro that runs fine if I open the visual basic editor and run from there, but if I use the run button on the excel visual basic toolbar it results in a memory error (could not be written) in exactly the same place every time. Why should it be doing this ! If it helps anybody, The macro generates a large number of commandbuttons on a number of sheets at specified places. I can't understand why it will run OK from the visual basic editor but not from excel itself. Can anybody shed any light to this ? Cheers Donna |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com