Then, without suggesting other changes to your code, and without seeing your
wb,
IF?? I understand your original question, try this.
c.Columns.autofit
c.EntireColumn.AutoFit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron Rosenfeld" wrote in message
...
On Sun, 28 Dec 2008 08:12:39 -0600, "Don Guillett"

wrote:

Ron,
As a retired stock broker this is something I do often. If desired, send
your workbook to me along with desires and I will see if I can make your
life a bit easier.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

Don,

Thanks for the offer. But I've got everything working to my liking,
except for
having to wait until MSNStockQuote updates the quotes before I can
auto-size my
sheet.

And that is only happening the first time through. (It's something I can
live
with for now).

I think it would be difficult for me to explain things in words. As an
exercise, I will try.

The methodology I use (in general), consists of generating a buy list
using
three separate screens from AAII Stock Investor Pro.

The number of positions to be purchased from each screen is a fixed
number. And
the position size ($) is determined by the particular screen (two of them
will
comprise 45% of my holdings, and the third 10%).

The actual position size is computed on information imported from
Microsoft
Money. It depends on the funds available in my investment accounts, which
will
include equity positions that can be closed, as well as cash; and also
determined by the amount of CASH I wish to have after making these
investments.

Then I need to check to see if I already have positions in the stocks on
the
buy list, so purchase/sale can be done to bring that to the determined
position
size.

Finally, the number of stocks to be purchased/sold is computed based on
the
desired position size, current price, and current holdings.

I do this once a year. And the total number of positions is 75, so
computer
assistance is pretty helpful.
--ron