ANmAddressSame

Checks if passed addresses are referring to same cell regardless of Absolute/Related references style, regardless of A1 or R1C1 styles
Returns 1 of CellAddress1 matches CellAddress2

Edit 2024-09-29: Fixing issue if one of passed addresses was 0

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Linkedin Login

RngAdd1, RngAdd2

ANmAddressSame("g2","R[2]C8")
Will return 1

Views 4

Downloads 0

CodeID
DB ID

ANmarAmdeen
711
Attachments
Revisions

v2.0

Sunday
September
29
2024
Needs