Current Cell Location

[mbshafe]

I want to be able to identify the address for the active cell to use within a match formula...is this possible?

 

[JamesW]

Hi,

Activecell.address will give you the address ($A$1) for example.

 

[mbshafe]

Thanks...is there a way to add the name of the current worksheet? I'm trying to create something to look like:

Deals!$A$1

 

[JamesW]

Hi,

activesheet.name will do this for you.

 

[mbshafe]

Do I combine the two into the function I created? If so, how? Thanks so much for your help

 

[JamesW]

Hi,

Can you post the function you created? Not sure how you want to use the 2 things above.

This might help though:

ActiveSheet.Name & "!" & ActiveCell.Address

 

[mbshafe]

I'm really stuck...I posted something yesterday about my overall problem, but I think it was too long and muddled so nobody responded.

Here is a formula I have:

=INDEX('Position Detail'!$1:$52,MATCH(Deals!A4,'Position Detail'!$B$1:$B$1000,0),MATCH(Deals!O2,'Position Detail'!$A$9:$AA$9,0))

I want to creat a reference to this formula to then evaluate. I am creating a spreadsheet that lists a variety of different asset classes, but the formula for Market Value is different for each asset class. I'm trying to avoid hard coding different formulas in each cell in a column, so my idea was to create a formulas page that I can refer to based on which asset class it is.

I don't even know if this makes sense!

 

[JamesW]

Ahh sorry, I read the OP as you wanted to use a VB solution. You can't use activecell.address etc in a formula.

I am not as good as I should be with INDEX/MATCH, so hopefully someone else will be able to help.

 

[mbshafe]

Thanks for the look anyway...it's good learning even though it doesn't solve my exact problem