Hi,
I am enclosing a file to show my issue.
I have event-change vba code in the first sheet. When i go to the first sheet and select say columns A through I and then delete them i get a run time error due to the event-change code.
Any ideas why? and How to prevent this? Or what should i do?
You are not getting this error because of deleting, but because of simply changing anything in your sheet, if your sheet is empty that is. This happens because It will see "A1" as the only used cell, making it column 1. So when you try to move 2 columns to the left with thisyou will get the message you are getting. To avoid it, you could use the following change in your code:
Please Login or Register to view this content.
Please Login or Register to view this content.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
That should work, but tell me if you keep having trouble.
That fixed it .....thanks!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks