Code please for incrementing text. For instance:
Text "D01-003" is in E7 and I need "D01-004" in E11
The following works but results in "D01-4" but I must maintain the "000"
format of the right three characters which need to go beyond "100"

HI I on sheet 2 of an excel file I have
Name       Age      weight     location
paul          10         150        calif
joe             8            90          az

very basic question. Does anyone know if there is a VBA-equivalent of
the "+=" operator in C.
i+=1 instead of i=i+1
thanks

I have a form with some controls on it. One of them is a multi select
listbox from which the user can select 1, 2 or more values. How can I
pass the values to my autofilter in VBA?
I understand that this is not possible using comboboxes?

I have an excel report that has lots of reports onto its sheets. When
the sheet i activated, the sheet immediately queries a database to
retrieve values. Indoing so, the screen keeps flickering which the
users find quite irritating. Application.screenupdating=False is not

My range is A1 to A10. Cell A1  I enter 100, cell A4 = 200, Cell 7 = 300.
Rest all cells in my range are blank. Now I want to copy 100 in A2, A3, 200
in A5, A6 and 300 in A8, A9, A10. Is it this possible through commands, like
Edit, goto, constants, then copy the select the blank ...

I use the code, part of which is extracted below, kindly written and
provided by Ron de Bruin,
which E-Mails a sheet called "e-Trip", how would I tweak this to set
the Importance to High (i.e. value =2) IF a value is >1 in SheetB!AA1.

Is it possible to enter a number in decimal but format the cell to display
the number in either binary or hexacecimal format?
I am running Microsoft Office Excel 2003 (11.8117.8122) SP2
Thank you,

Have several spreadsheets that have the name of people in one column in the
format - lastname, firstname MiddleInitial.
What I need to do is read that info and parse out each piece of info into
it's own column.  One thing I am concerned with is some of the names do not

I've been asked to see if it's possible to get a "bouncing bar"
progress indicator control in Excel.
A "bouncing bar" is the kind of progress indicator that looks like a
normal progress indicator, but instead of the bar filling up from left

Hi -
 I'm building an App where the User's Wbk is referenced to an Addin.
 A 'parm' sheet in the user's wbk has a sheet change event macro.
 call MgrEdit(target.address)   ' the edit macro is in the addin

I'm in the process of creating a change log.  The intention is to store any
change to any cell in the workbook, ideally including formatting changes.  
Each time a cell is changed, both the old and new values should be stored.  
I'm using the SheetChange workbook event.  The ...

In Excel2000, what are the boxes at the right end of the Status Bar for?
Alan Beban

Can each sheet in a workbook have a separate custom Menu? If so, how is a
sheet's custom menu activated when the sheet is opened?
Thanks!
Steve

I have a worksheet that some of our staff uses to input their hours into.  
Under a client section, they have a list box that allows them to select the
client they are working for.  However, I want them to be able to add a new
client if it is not already listed.