refering to address
 

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!!!!

refering to address
 

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)

"april27" wrote in message
...
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!!!!