Is there a way to control the text properties of the body text?  For
example: bold, italics, underlined, etc.
I've got code like this to enter the body text.
           .APPENDTEXT "This is a test."

I have search through prior posting of how to find last row, then sort from
that information, But I must be doing something wrong becasue I still get a
error message.  Also the first cell will always be 'A3'.
Here is the code that I have put together:

I got several VBA functions defined and try to use it in excel 2003, but I
got name error, the functions work very well in others' computer with
different excel version. do you have any ideas of the reason? thank you very
much!

I am facing a problem in intialising a string array in VBA. I need to
intialise an array of 10 elements from data in a range. This range has
text values. I tried to use following.
[code]

Can somebody explain what this section of code does?  It is located i
Sheet1 of the VBA Explorer in Excel.
Here it is:
On Error GoTo errorhandler

I was wondering if someone could help me out a little as I think I am
going to go completely crazy if I spend another minute scanning through
the archives in these groups.
My problem is that I have a user form that I use to view and edit data

I would like to open each workbook in a folder, get some information from it
and close it.  How can that be done?  I can get the path but when I do
workbooks count, it just counts the open workbooks.
Thanks,

I need to Wrap an existing formularized Cell with the Function  =VALUE()
using a VBA Statement.  The below is not quite working . Can someone assist
me in getting the proper syntax to get it going???
Tks in Advance..

I have table - price list with reference number and description like
this:
Reference number    Description  
1. 234567                  busbar

I have an Excel Sheet "Sheet1" in Column A from Row 6 down to Row 140 I have
sequential numbers from 1 to 135. In Column B again from Row 6 down to Row
140 I have the single letters E, W, N in no particular order. Is it possible
to have a routine that will place a number 1 in ...

A vba speed bottleneck can be the transfer of data between the workbook and
the macro.
Will 2007 address this issue, perhaps with multithreading?
Regards

i want creat a macro that stop to delete workbook.
thanks in advance.

The file that the following calls up, requires an "enter",
to accept the default yes/no statement (actually "do NOT
Sub BB_Chassis_Draft()
   Application.ScreenUpdating = False

I'm having a little problem. I'm trying to calculate a formula whic
grows for every calculation I must make. I always have to use th
solver so it takes a while to get it done. Here is my problem.
For x that goes from 1 to 30 (all integers), I want to evaluate "m".

I am working with a listview control under the .view = lvwReport setting.  I
add one column header and set the column width to 200.  When I add a listitem
to the listview, the width of the listitem is well under 200 and is not
displaying the entire text of the listitem.  The ...