How can I use excel VBA to paste part of a cell's text in the cell below?

[smith310]

I want all cells that contain the text "tonight's movie:" to have the text that comes after the "movie:" to be pasted in the cell below it. If you can help, I would really appreciate it. Thanks!

[HaHoBe]

Hi, smith310,

starting for one cell you may proceed like this (no loop as I do not know if the next cells are always empty or need to be inserted, and then: only one cell or one row):

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[smith310]

thanks for the quick reply! sorry, but neither of those macros worked. i am looking for a macro that will take the words to the right of "tonight's movie:" and put it in the cell directly below it. the cell directly below it will initially be empty. I want this to work for all cells in the sheet which contain the words "tonight's movie:"
thank you for trying to help. you are awesome!

[HaHoBe]

Hi, smith310,

...but neither of those macros worked.

Might it be that you either didnīt select the cell with this content or maybe itīs not values but formulas in the cells?

Please Login or Register  to view this content.

Ciao,
Holger

[smith310]

It worked!! Thank you so much!