I am new to VBA so this is going to sound beginner (sorry). How do I save a selection of text for later use in the macro?

I need to look for text, tab to the next cell, and copy the contents of that cell for later use.

Thanks for any help you all can provide!

Brock