active cell range

  • Thread starter Thread starter Atishoo
  • Start date Start date
A

Atishoo

Does anyone know how to return the active cell reference (just as in the name
box) in a cell without using VBA is there a formula that does this or is
there a way of refering to the active cell in an "if" formula in a cell.
 
First off if you are looking for a non-vba solution programming is not the
best forum to be in. That being said the only way to refre to the active cell
is via VBA. There are no inherant functions that will do that. Additionally
since moving the active cell does not cause a calculation to fire you can not
effectively use a user defined funciton. Your best bet would be to use the
selection change event in VBA...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel VBA 1
Name Range Help 1
Named Range maker code 9
ActiveCell on inactive sheet 8
Paste a range and shifting away existing data 1
clear all sheets code 4
Autofill a dynamic range with a formula. 1

Back
Top