Excel 2000 -Revise Dim

[Gerry Cornell]

I used this statement in a macro I created in 2000. I think it should
be capable of modifying to it make more usable in other situations.

Range("PAGEHEAD").Select
Dim Y
Y = InputBox("Enter Pagehead")
If Y = "" Then Exit Sub
ActiveCell.Value = Y
Range("PAGEHEAD").Select

Thus if the PAGEHEAD is "Bank summary for December" how can one make
so that you only need to enter "January" instead of entering "Bank
summary for January to".

TIA


--

~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~

 

[Ardus Petus]

Try:

ActiveCell.Value = "Bank summary for " & Y

HTH