How to name active cell which ever cell is activecell

[Launchnet]

I need to name a cell that is the active cell. The active cell can be any cell that is selected at the time I need to name it. I can get it to name the cell using the cell address, but I don't know how to change it to the active cell.

Below is the code that I tried, but the syntax that I tried to say what cell is to be named simply isn't correct.

ActiveWorkbook.Names.Add Name:="BelowDeletedCell", range("activecell")

Need a little help please.

[Paul]

Hi Matt, perhaps just:

ActiveWorkbook.Names.Add Name:="Paul2", RefersTo:=ActiveCell

[Launchnet]

Thanks Paul . . . Did the trick !