How to make a selection of cells "active cells"

I need to make the selection of cells all active cells, rather than the first one I clicked on. Right now I have the code as

Sub SELECTIONLOSE()
'
' SELECTIONLOSE Macro
'

'
ActiveCell.FormulaR1C1 = "=-R8C5"

End Sub


I can't seem to find a way to make a selection a set of active "cells" and even found trouble just trying to record the macro, as the selected cells only returned the first cell I clicked as an active cell. I want the selected cells all to return the same forumla, but I don't want a set fill range.

As I understand it you can only have one activecell but instead of activecell.formular1c1 you can use:

Please Login or Register  to view this content.

to apply it to all of them.

Hey thanks for the tip, it worked! I can't believe I overlooked that haha such a simple fix