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