How do I change the active cell in a non contiguous range or selection?

[ptroiano]

I know that "tab" "enter" etc change the active cell in a non contiguous range in the spreadsheet .
What I would like to do is have the macro do the same thing.

How do I get a macro to change the active cell in a non contiguous range or selection?

Thanks for any suggestions.
ptroiano