relative addressing in code

[Kim]

Given a properly formatted date and code of CurMonth = Month([A400]) how can
I move the cell with date(A400) and have code follow change? I've tried many
things -- none work.

What am I missing?

Thanks,

Kim

[Bob Phillips]

Name the cell (Insert>Name>Define ...), and use that name

CurMonth = Month(Range("named_cell"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kim" <Kim@discussions.microsoft.com> wrote in message
news:8071E965-0B72-4C47-BC1E-B2A9D0C0B7E4@microsoft.com...
> Given a properly formatted date and code of CurMonth = Month([A400]) how
can
> I move the cell with date(A400) and have code follow change? I've tried
many
> things -- none work.
>
> What am I missing?
>
> Thanks,
>
> Kim
>
>