Excel 2000 -Revise Dim
 

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

Excel 2000 -Revise Dim
 

Try:

ActiveCell.Value = "Bank summary for " & Y

HTH
--
AP

"Gerry Cornell" a écrit dans le message de news:
...


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