I am trying to create a dynamic model which allows a user to record financial data. One simple function allows a user to systematically add a column to a sheet with the following macro:
It was working perfectly but for some reason it started coping and pasting columns A:H, instead of column H. Why/how did this bug occur? How can I resolve it?
Please Login or Register to view this content.
Last edited by Leith Ross; 06-03-2015 at 01:15 PM. Reason: Added Code Tags
are you sure that's exactly the code in the module..? i don't see any reason that would happen. but, you don't really need all the ".select" and "selection." noise. this might work better:
Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Hello djl295,
When code I have been using for sometime suddenly stops working, I defragement both my main drive and the registry. This generally fixes the problem.
To defragment the registry, you will need a third party program. Microsoft does not supply one as part of the Windows operating system.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks