Cell formula that will give back the address of the cursor?
in [Functions]
|
Prev: Finding the cell loacation that matches a specific value in a
Next: how to calculate billable rate using base rate and percentage
From: Byron on 24 Feb 2010 17:11 There HAS to be a formula so that I need NOT go thru VBA to obtain the current position of the cell pointer! Has to be! This CAN'T be new? Is there anyway to access the 'Name Box"?
From: T. Valko on 24 Feb 2010 22:04
I don't think you can do this without a selection change event macro. Simply selecting a cell does not trigger a calculation so a formula wouldn't update. This formula will return the active cell address but it will only update when some event triggers a calculation. =CELL("address") Probably not what you had in mind! -- Biff Microsoft Excel MVP "Byron" <Byron(a)discussions.microsoft.com> wrote in message news:29F82BA8-0C8C-42F9-8EA3-7CB00C52AE37(a)microsoft.com... > There HAS to be a formula so that I need NOT go thru VBA to obtain the > current position of the cell pointer! Has to be! This CAN'T be new? Is > there anyway to access the 'Name Box"? |