Hello,
I'm building a simple search function in my workbook. I
have no problem in locating specified text, but I do not
know how to 'get' the location of the current cell, I
tried:

CellMatch = ActiveCell

But, alas, this simply assigns the value of the currently
selected cell to CellMatch. I want the location, "A2" for
example.
Thanks in advance
Mat.

Hi Mat
try
sub foo()
dim rng as range
set rng = Activecell
'to get the value use
msgbox rng.value
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

Mat wrote:
Hello,
I'm building a simple search function in my workbook. I
have no problem in locating specified text, but I do not
know how to 'get' the location of the current cell, I
tried:

CellMatch = ActiveCell

But, alas, this simply assigns the value of the currently
selected cell to CellMatch. I want the location, "A2" for
example.
Thanks in advance
Mat.

Mat

Sub gronk()
Set currcel = Application.ActiveCell
MsgBox currcel.Address
End Sub

Gord Dibben Excel MVP

On Sat, 21 Feb 2004 10:45:33 -0800, "Mat" wrote:

Hello,
I'm building a simple search function in my workbook. I
have no problem in locating specified text, but I do not
know how to 'get' the location of the current cell, I
tried:

CellMatch = ActiveCell

But, alas, this simply assigns the value of the currently
selected cell to CellMatch. I want the location, "A2" for
example.
Thanks in advance
Mat.

Thanks, got it working now :)

"Mat" wrote in message
...
Hello,
I'm building a simple search function in my workbook. I
have no problem in locating specified text, but I do not
know how to 'get' the location of the current cell, I
tried:

CellMatch = ActiveCell

But, alas, this simply assigns the value of the currently
selected cell to CellMatch. I want the location, "A2" for
example.
Thanks in advance
Mat.