Afternoon happy campers,
Could you please tell me how to make this shorter (hopefully more efficient) as i was previously told that the mroe times i 'Select' something the longer it can take to complete the code?
Please Login or Register to view this content.
Kind Regards, galvinpaddy
I reckon that's just
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
On a dummy file, i inserted 3 buttons using the Developer menu (Developer - Insert - choose command button).
The name that appeared for me on the buttons was "Button 1".
So i edited your code to delete those buttons and have this as the final codePlease Login or Register to view this content.
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]
why use shaperanges at all if you're gonna delete them one by one? ;-)
Yeah. I hardly use arrays, always get stuck with them
Thanks anyways JP, it was learning for me too.
what I mean is your code could just be
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks