Name an active cell

[BabaK]

Hello

I would like to be able to name a selected (active) cell in a workbook without having to give the cell reference. This is because the active cell will change depending on previous actions.

e.g

Please Login or Register  to view this content.

I know I need to have something after "RefersTo" but I don't know what.

Thanks

[davesexcel]

try this

Please Login or Register  to view this content.

[sweep]

Hi,

Try this:

Please Login or Register  to view this content.