The macro you want is quite simple:

ActiveCell.Value = ActiveCell.Value

Here are the other wish list items:
1. I am not quite sure of what you are trying to do here. It seems like you
want to scan and find the last column that has an entry. This can be done
using a loop. Here is a macro I used to find the last row. The same can be
done for finding the last column:

' return last active line with a name in it
Function LastLine() As Integer
    Dim i As Integer
    Dim C As String
    i = Start
    C = "B" & Start
    Range(C).Select
    Do While ActiveCell.Value > ""
        i = i + 1
        C = "B" & i
        Range(C).Select
    Loop
    LastLine = i - 1
End Function

2. This can be changed easily. Go to Control Panel/User Accounts and select
"Change the way users log on or off". Check the box for "Use the Welcome
screen".

3. Just drag the programs with a right mouse click and create a shortcut in
the Startup Folder. This will usually be at:
C:\Documents and Settings\*username*\Start Menu\Programs\Startup

You may have to enable viewing of hidden/system folders to see the Documents
and Settings area.

4. Sounds like you have screen saver enabled. Right click on your desktop
and select properties. Then the Screen Saver tab and disable the screen
saver.

Merry Christmas!

Peter
----------------------------------
[log in to unmask]

-----Original Message-----
Detail: My "Investment Record" spreadsheet has columns:  Stock name; number
of shares;  date purchased; cost.   Then a  pair of columns for each month:
that month's stock price (which I enter manually) and the current value of
the investment (which has embedded formula: "number of shares" column times
"stock price")  This works fine until there is a stock split, or I buy or
sell shares.  If I change the number of shares, all the prior months values
change - which I don't want to happen.  So I have to type in the value
numbers for each prior month, overriding the formula.  A pain!  I would like
to select all the prior months and then, with a few clicks or keystrokes,
replace the embedded formula in those months with the numeric values that
the formula had generated. If this involves creating a Macro, I need some
detailed info - I know naught of Macros!

Other desires (Christmas IS coming):

1.  I would like to add a column titled "Annualized change" that would be a
function of the following columns: "Cost"; "Date Purchased"; "Current Value"
using the value in, and the date of,  the last column in which a value has
been  entered. (I'd probably have to forget adjusting for changes in the
number of shares)   Doable?

2.  I am the only user of my computer, which is at home.  And I'm very lazy
When I boot I would like to skip clicking on to my "Identity" - I'd like it
to boot directly to my Desktop...

3.  ...and when it boots I would also like to have several programs - maybe
Real, OE, Firefox - load automatically.  They are now in my bottom tray, on
the left.

4.  And, finally, if the PC is idle for 5? minutes, I have to hit a key,
which first brings up my desktop, then asks me to click my identity to bring
it back to life.  I'd like to have the screen and programs to remain as-is.
(If I'm inactive for an extended time I turn off my monitor).

    Replies to the forum, or privately, will be greeted with overwhelming
gratitude - and warm Holiday wishes!

           - Jim Harris,  Philadelphia

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com