LinkBack URL
About LinkBacks
and then I "find the last cell" and range.fill am I acting ONLY on the subset?
I ask cuz the row nums are the "original" ones rather than a "new" set of 1,2,3,etc (they're like "11,33,34,624,....etc")
and then I "find the last cell" and range.fill am I acting ONLY on the subset?
I ask cuz the row nums are the "original" ones rather than a "new" set of 1,2,3,etc (they're like "11,33,34,624,....etc")
Yes you are acting only on the subset.
What actions do you want to perform after filtering?
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]
THank you.
I'm doing an index with a nested match that has 2 concatenated criteria and arrays. Its a bit time consuming to process, but its a one-shot deal (there are many 200-800 member facilities within this 33k pool of people. Each facility will run this particular machination once).
So this is solved?
Please mark your thread as solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks