Excel 2000 -Revise Dim

  • Thread starter Thread starter Gerry Cornell
  • Start date Start date
G

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