You don't really need VBA to do what you want.

Did you try this in A2 ?

Format - Cells - Custom

"Next Week ("0")"

In A2, put this:

A2: =IF(ISBLANK(A1),"",A1+1)

If you want a VBA solution, come back and let us know.


"NOOBY92" wrote:

Hello, I am completley new to Visual Basic. I have XP SP2 and Excel 2002 Here
is what I need.

I want to make a regular character (for example "x") a variable.
Then I want to use that variable in other cells.
For Example.

Cell A1- Week x /I want to make x a variable/
Cell A2- Next Week (Week ) /I want "x+1" to appear after "(Week " but I
don't want anything to appear after "(Week " until the value for X is
determined/


Thank You Very Much