Macro search for number with variable steps

Is there only one instance of MF1, MF2 etc?

Will it always be sequential - i.e. MF1, MF2, MF3 or could you have MF2, MF4, MF7?

There is only one instance of MF1, MF2 etc and they will always be in sequential order. There are numbers elsewhere in the sheet though .

Thanks

Try this:

Please Login or Register  to view this content.

Hey Stephen,

That doesn't seem to do anything, it returns an error when I step through on
SearchFormat:=False - I am running excel 2000 is that why?
When I removed that from the macro it runs ok but it just twice through the loop and ends without finding anything when my spreadsheet in this case had MF1, MF2.

Just to add to the problem, I forgot to mention that it is likely that there might be more text after the MFn. Does this change the code dramatically or can I put the string after the i in "".

Cheers for the help so far.
Cei

Cei - please attach a small sample workbook showing your data as is.

Stephen,

I have attached a sample of what of I am trying to do. The idea is to basically move the text from rows into columns. I have already written the macro to add the headings (responsibilities), that was pretty simple. But so I need to move the MF1 Pete - to the same row as MF1 Dave - under the Pete responsibilities column. The column and cell numbers won't always be the same, but it will always be MF1 Pete -, MF1 Dave - and the movement will always be across to the right 2 cells and up 1 cell.

Hope that is enough information, if you need anymore then let me know.
Cheers
Cei

OK, this isn't quite as I envisaged from your post. Could you add to your attachment how you want things to end up as I'm not quite sure?

Sorry for the confusion! Here's the proposed end result, though the moving of the MF is not important (just to show you which cell is moving).

Cheers

This works for your example but not sure it will cater for all eventualities.

Please Login or Register  to view this content.

Can you just remove that bit? If it doesn't work check you haven't any predefined formats by pressing Ctrl+F from the worksheet and clearing formats.

No that doesn't seem to work, when I remove the argument it just seems to loop through twice and then end, without actually moving anything. So the code I have ended up with is below, all I have done is remove argument that fails.
I have tried to remove formatting. If I press Ctrl+F in the worksheet it brings up the find dialog box.

Any more ideas?

Please Login or Register  to view this content.

Cheers
Cei

I'm sort of stumped actually. Are you running it on the example you posted? If a different file it might be a problem with the sheet reference. Or another issue with Excel 2000.

Ok, not quite sure why it didn't work. Tried it on an excel 2007 version both with the argument and without and it worked. So tried it on the spreadsheet again and it worked. The reason it wasn't working seems to be that there was another macro in the worksheet, not that I was running it. Maybe that isn't the reason...

Anyway it is working now, so that is all that matters.
Thanks so much for the help, sorry its taken so long!

Cheers
Cei