Macro to copy a cell to ANY pre-selected (non-adjacent) cells

[lotusman]

I'd like a macro to take a bunch of pre-selected cells - mostly non-adjacent to each other - and give them a range name, and then copy another (also range-named) cell to that range, and then delete that range name that was just given to those particular cells. My problem is (I record macros & try to edit as best I can) that, next time round, with a different selection of cells, the macro will assign the name to the earlier-selected cells, and not to the actual 'current' selection of cells. If someone could write me these few lines of code that I'm looking for, I'd be very grateful, thanks. Happy to clarify any aspect of this. Thanks.

Lotusman

[6StringJazzer]

Please show the code you have to start with.

Why do you want to create a name range then immediately delete it?

[Bernie Deitrick]

Please Login or Register  to view this content.

[lotusman]

[SOLVED] Bernie, thanks very much! That worked. This is the sort of simple text I need to learn more of, that does not seem to get produced when recording macros . . . Appreciated.

Lotusman