VBA: Extracting coordinates of an active cell

Question

I am new to Excel VBA and what I want to do is the following.

Currently the cell "F3" is active, and I would like to know if there is a function that returns the value "F3".

I imagine that there is a way to extract the 'coordinate' of F3 as (6,3) since F is the 6th letter and 3 is simply 3 (maybe (3,6) if it counts row first and columns later).

If it can return something like (F,3) it would be even better, and best case scenario, F (the column LETTER) by itself.

It is imperative that I am able to extract the column letters because I intend to use this as an input to "replace all letter A to letter B".

If you have an exact answer that would be great, but if you could guide me towards a useful link that would be appreciated, too.

Thank you!!

Harun24hr · Accepted Answer · 2022-07-01 03:35:06Z

2

Try below sub-

Sub GetCellAddress()
Dim x As Variant
    x = Split(ActiveCell.Address, "$")
    MsgBox x(1) & "," & x(2)
End Sub

Result in message box: F,3

answered Jul 1, 2022 at 3:35

Harun24hr

38k6 gold badges24 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hyg17 Over a year ago

Thank you! That was very useful (: So many useful tools in such a small code.

Collectives™ on Stack Overflow

VBA: Extracting coordinates of an active cell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related