refering to address

[Guest]

i am making a macro for excel that searches a spreadsheet and then makes a
chart. i do not know how to refer to the address of a cell properly. i search
for cell by using the following function:

Set rng = Worksheets("Indata").Cells.Find("Date", LookIn:=xlValues)

In antother subroutine i want to create a chart. I want the range of the
chart to start at the position where i found the word "Date". I recorded a
macro making a chart. However i dont know how to change the reference. The
code of the recorded macro:

Range(someTextHere).Select

I dont know what to write in someTextHere so that it refers to my cell.
PLease please help me! I really cant figure it out and have tried different
solutions!!!!

 

[Bob Phillips]

Use the Address property of the range object to get the address.

But in your example, you have a range object, so just select that

rng.Select

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)