Solved: Pretty Simple VBA question

[picklepuss]

I'm sure this is very simple, but since I am self-taught there are tremendous holes in my VBA knowledge.

I have a macro that does several things, including entering a second section on a spreadsheet (so the row location of that section's header will be variable). In the second section header, I need to define a cell for input box data to go into.

What is the best way for me to define a variable cell so that it becomes where the data from the input box (later in the macro) will go?

e.g. (this does not work but shows what I am looking for)
Dim DateCell As Range
ActiveCell = DateCell

**other stuff happens in macro**

Dim Dateinput As Date
Dateinput = InputBox ("What date is it? (m/d/yyyy)")
MyDate = Dateinput
Range("DateCell").Value = MyDate

Thanks for any help!!!

 

[picklepuss]

Was able to solve myself -

Dim DateCell As String
DateCell = ActiveCell.Address

**other stuff**

Dim Dateinput, MyDate As Date
Dateinput = InputBox("What date is it? (m/d/yyyy)")
MyDate = Dateinput
Range(DateCell).Value = MyDate