See my reply it is (IMO better.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
...
Well I got it. I had to add .address to the very end.
Below is what I chaged the code to:

FindRangeAddress = Workbooks("Completed Followup Detail
CSS.XLS").Sheets("WOW Reps").Range("A3:A3000").Find
(Cell).Address


-----Original Message-----
Hi Todd

FindRange.Address

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Todd Huttenstine"
skrev i en
meddelelse ...
Hey guys

Below is a code that looks in Range A3:A3000 and sets
FindRange = Cell1. How would I return the actual cell
address value of FindRange?


Dim Cell1 As Object
Dim FindRange

FindRange = Workbooks("Completed Followup Detail
CSS.XLS").Sheets("WOW Reps").Range("A3:A3000").Find
(Cell1)

Thanks
Todd Huttenstine


.