View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Matthew John Antoszkiw Matthew John Antoszkiw is offline
external usenet poster
 
Posts: 6
Default Get active cell?

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.