vba error.PNG I am hereby attaching a VBA error screen shot , I am not getting why this error populates sometimes and even not for a so big coding .. down I am parsing the code.
ah one more thing is the sheet is protected one but the cell which i want to edit had been is unlocked. It would be great if someone points out the root cause.
Please Login or Register to view this content.
I have got this error in the past. It usually happens when you have less memory to execute the whole code. You can do 2 things - 1. Either click Continue each time this popup appears.
2. Stop the macro when its running and close other excel files that are open (if any). Check what your RAM utilization is at that time and if there are too many processes running in your computer which are not needed. You can check this using the Task Manager.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
That whole code snippet can be re-written as:
Please Login or Register to view this content.
thank you firefly , added rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks