Set range to every 7th cell
I currently used this code attached to a command button to search and find employees in my company by their surname
although the row now includes both names and other details, is there a way I can still only search for the surname?
The surname is in every 7th cell along (starting at E1... L1... S1 ect)
Would there be any way to set the range for every 7th cell in the row ?
Please Login or Register to view this content.
Hi justmegan,
I believe the answer is yes, but would it be possible to see the sheet to understand a little better? You want the range to be every 7th cell in the row, but your range is the range where the name matched... so if you just select every 7th cell, does that not mean you are selecting all surnames?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Every 7th cell, I would just use a for...next with a step of 7
Or something along those linesPlease Login or Register to view this content.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Thank you SpeshulPlease Login or Register to view this content.
Got it to work now!
Last edited by Justmegan93; 03-16-2015 at 08:42 AM. Reason: Typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks