Hi,
With some help from user OssieMac,
I was able to get the code to this point, but I think I may need some help
to get to the next step.

How to sort ignoring letters, Excel 2003
ny only containing numbers,
For example
default sorting                        wanted sorting

I am currently in pain over the Sarbanes-Oxley rules and what they are
requiring.  I am not sure if I am so upset over the requirements or what
appears to be manangements and Sarbanes auditors lack of knowledge of how to
use excel.  The Sarbanes people want to throw more people ...

I added a chart to my workbook using the Sheets.Add command, with the "Type"
parameter set to xlChart.
But when I walk through the sheets in my workbook and check the "Type" of
each, it tells me that my chart is an xlExcel4MacroSheet instead of an

Why dosn't this work? Thanks
   Sheets("INPUT_A").Select
   If OptionButton2.Value = True Then
       Sheets("AR").Select

I am using Ron's code to send several sections of my Wksheet. Works well,
except that I would like to control the font size in which each section is
embedded in the body of the e-mail. Is there a way to control this?
http://www.rondebruin.nl/mail/folder2/mail4.htm

I am trying to put together a tool that can can search, column by column,
for a certain background/fill color (yellow), and then copy/paste the
value/text in various columns of the same row for each instance of yellow
background colored cells, into another worksheet.

I have a textbox in a userform that I want to only accept numbers and '/' to
enter dates.  How do I do that?
Thanks

I have an excel table that is imported from Access. I have a column named
Price and I need a column next to it called Date that will show when that
specific price is updated.
I have been searching around and most of the things I have come across have

I've been having a lot of problems and it seems to be that the macro works
perfect the first time; however, when I run it again, the user forms are
shifted around, the combobox value can't be set to show blank, etc.  It also
does not do the initialize code in the form after it ...

I'm not even sure this can be done. What am trying to do is sort data from
Sheet 1 and place the sorted data on sheet 2 & 3.
Here is what the data would look like:
1 BLOCKNAME   ADDRESS1     STROBE_CIRCUIT_INFO   SPEAKER_CIRCUIT_INFO  

This is driving me insane!!!
I'm trying to have the text of all of the controltiptext properties on
a userform to be the same as the caption property of the label
(there's loads of labels).

Hi how do I return a web browser address into a cell as per the following
example??
Cells(ActiveCell.Row, "ar").Value = ActiveSheet.Shapes("WebBrowser2").Address

Is there any way to program a workbook so that I am able to click on any
individual cell in a workbook, which contains multiple sheets, that would
then serach the entire workbook and automatically locate/find any other rows
in the entire workbook that contains information ...

I think this is possible but I'm not certain of the way the code would look.
I have an extract that comes to me in Excel format and I have a Macro that
runs through the Excel file reformatting it. The extract will have several
hundred rows.