Search results for query: *

I am trying to find code that will result in all the variations in any order of a group of numbers, for example, 1,2,3,4,5. The result of running the code would give me 1,2,3,4,5, 1,3,2,4,5, 1,4,2,3,5, etc. until running through all combinations without repeating. Would anyone be willing to help me?

You are right, however now when I run the code I get a "Type Mismatch" error. When you do find can you input "cells" code to look up or is there some way I can use the "Find Next" code?

The problem with that is that instead of it putting me in the Q column or column 17 it will put me in the I column and will be looking up the wrong info.

I was helped here yesterday creating a "Find" code that was successful. I thought I would be able to modify it based on what little I know but was unsuccessful. Here is the code I used. This is not the code I got yesterday, yesterday was purely a "Find" code which worked great, this is how I...

Thank you Skip, I appreciate everything, I struggled for hours and you guys helped me in minutes, I'm going to input it in with my macros I have done and hopefully it all comes out. Really appreciate your help.

Guys, thank you for your help. PHV, I input that code and it seems to have worked. I'll put it in with the others I have done with Macros and see if I can't get the whole shabang to work. If not "I'll be back". Really do appreciate everything guys. Thanks

Skip, I appreciate your help. When I copy and paste the code and run it the cursor goes to the table but doesn't select the cell from A2, it instead goes to the first row and second column in the table regardless of what I put into A2 to find. Any advice? Even though I have changed the value in...

I am trying to write a code to "find" the value in a cell, for this example we will say cell A2, in a table on the same worksheet. So if the table is in range A5:F50 and I want to "Find" the value in cell A2 in that range and then leave the cursor on that cell once it's found how can I do that...

I am unfamiliar with VBA but have most of what I want to get done using macros, however I am trying to write a code in VBA that looks up the value in B2 in a data set in range a4:f50. Once it finds that value I just want the cursor to be in the cell where it found the value. Can anyone help me...