Referring to Active Cell Selection

Hi

I want to refer to the current selection of cells in my Macro (whatever length that selection may be).

Range("A5").Value = Range(&Selected&)

I have currently come up with that (just for getting 1 selected cell value to appear in another cell. It is not working however.

The ultimate goal is to get a macro to insert a formula into a cell that says.

"=Count("INSERT THE MISSING FUNCTION REFERRING TO CURRENTLY ACTIVE SELECTED CELLS HERE")

I can do everything but the bit in caps

Thank you in advance

Assuming the selected range is A1:A4 then this will in B1 add the formula
=COUNT(A1:A4)

Please Login or Register  to view this content.

Alter the false arguments to true to get variation absolute references to the selection