Hello,
The below code is situated in a sheet and when i try selecting columns anywhere within the sheet excel buffers for about half a minute
Not sure what part of the code is causing this but i would really be grateful to anyone who can point me in the right direction.
Please Login or Register to view this content.
Last edited by kosherboy; 04-01-2016 at 02:58 PM.
Maybe ...
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Is there some circonstances when the issue happen: A large range of cells selected ?
For me with no value in the sheet and doing the selection of one cell, it is OK
Can you send a sample of you file
- Battle without fear gives no glory - Just try
Lately i've been having trouble uploading files onto this forum.Originally Posted by PCI
I put the code into a blank sheet and when i selected several columns the buffering started.
Yes, that worked!
Can you explain to me what i did wrong in the code and why it was acting funny?
If you selected the whole column, the code would have to ratchet through a million cells. If you selected the whole sheet, 17 billion.
Wow! I wouldn't want that to happen.
Thanks for explaining it to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks