Finding the address of a matched cell with VBA

[PoroBro]

Hey.

I need to change the below cell code into VBA code.
=ADDRESS($O$7;MATCH(K7;'3rd exercise'!3:3;0))

Just to clarify, I am trying to remove unnecessary cells from the worksheets, so all the cell references are already variables in the code, except for the '3rd exercise'!3:3 as it is a value that has to be looked for.

I am new to VBA so if you can add anything to clarify how everything works, I'd love it. Thanks upfront!

 

[wideboydixon]

Assuming you have the value from $O$7 stored in a variable called rowNum and you have the value from K7 stored in a variable called findVal then it would be something like this:

rowNum = Range("O7").Value
findVal = Range("K7").Value
cellAddress = Cells(rowNum, Application.Match(findVal, Sheets("3rd exercise").Range("3:3"), 0)).Address

I haven't run or tested this code however.

WBD

 

[PoroBro]

It works like clockwork!

Thank you very much!