Hi there
I have the following code which paste special all rows where column F is "Y"
Is there a way this code can be changed so that only columns A - F are 'paste special vaules'
Please Login or Register to view this content.
Thanks
Hi there
I have the following code which paste special all rows where column F is "Y"
Is there a way this code can be changed so that only columns A - F are 'paste special vaules'
Please Login or Register to view this content.
Thanks
Hi uncleslinky,
You can use more with statements to make the code run quicker
Please Login or Register to view this content.
Try this
It might be faster to use AutoFilter depending on the data layout.Please Login or Register to view this content.
Last edited by royUK; 03-15-2011 at 04:52 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Try thisPlease Login or Register to view this content.
guys, thats great thanks!!
the only left out was resize
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks