ICell Selections into Range Argument

[EnigmaMatter]

Hello All,

I have a Macro that executes code on all of the (contiguous and non-contiguous) cells the user has selected AND a fixed cell that I have set at A4000.

For example, the user may have selected B2 and B4. The fixed cell is at A4000.

How do I set the argument/code up so that it takes the user selected cells and the fixed cell?

Please Login or Register  to view this content.

The cells always change, so B2 and B4 cannot be hard coded! How do I write the above statement so that it plugs in B2 and B4 (or however many cells are selected) in addition to cell A4000?

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[EnigmaMatter]

Wow.

Thanks.

[TMS]

You're welcome. Thanks for the rep.

[EnigmaMatter]

http://www.excelforum.com/excel-prog...ml#post3594062

Could you give this one a shot?