Hi all
New to this board and wanting to improve my macro skills. I'm using a macro that has been floating about on the internet. My issue is that I want to keep a block of text from rows 1-8 inclusive and then run this macro with A9 being the A1 as in the code below.
Am imagining that this would be quite simple so would love some help here.
Thanks!
Moderator Note:
Please Login or Register to view this content.
Pls use code tags around your code next time as per forum rules.
Last edited by Fotis1991; 10-07-2013 at 04:22 AM.
Not entirely sure if you want to change the filtered rows, or the starting row to filter rows.
If you want to copy rows stating from A9, change this line
INTOPlease Login or Register to view this content.
Or if you want to copy the filtered rows starting from A9, change this linePlease Login or Register to view this content.
INTOPlease Login or Register to view this content.
Please Login or Register to view this content.
I've attached a .jpg file. I want to keep the first 8 rows the way they are and have the filtered rows start from A9.
test.jpg
Change this line
INTOPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you. That works!
Last edited by keeptabs; 10-07-2013 at 06:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks