I have an excel table that has thousands of cells that are
"1.375 in (35 mm)"   How can I seperate each measurement into a new cell?
e.g.  "1.375"  &  "35"

what version of excel introduced the subtotal function numbers 101-111? was it 2003?

I have an Excel document that gets saved on a daily basis.  I have it working
except when I save the worksheet as a tempalte it ignores the unc path it is
set to save to and saves it to my documents instead.  I think it is because
when you oepn up the template it appends the name ...

If not, how it can be constructed? Any smart way?
Thanks,
Jo

I have a small range of cells say E4:E8 that I named myRange
As one group I formatted the cells to be of type Number
with no initial values stored in the cells.
I use a " For Each Cell in myRange"  loop to cycle through these

I have a program C:\Qoutes\qq2.xls
I have the original for this workbook at \\server3\Quotes\qq2.xls
I update this workbook almost weekly.
I them email everybody to download the updated version.

I have a userform I'm using to prompt the user to update a list where the
data is held in a worksheet.  Each time the user presses the "update" button
in the book, the userform for the udpate is accessed via userform.show.  On
initializaion, I use a list box that adds items based ...

I would like to remove the N/A's and replace them with a 0 but none of
these macros seem to be working properly. Two problems that I
encountered is that is (1) the macro does run but by replacing all the
cells with a 0 (2) it does not stay within the data range, so it runs

Please can someone tell me what this is used for with the Insert method.  I
was hoping to be able to copy the contents of a row, and insert it below the
source row using this facility.

I have created an App in Excel that I would like to display the
"Window Caption - MyApp Name" instead MyApp filename and " - Microsoft
Excel" in the Title Bar.
Is there a way to update the "HKEY_CURRENT_USER\Software\Microsoft

My Workbook_Open() code is simply
 UserForm1.Show
UserForm1 has four buttons.  At this point, I'm only using CB2, which
has code

I have an add-in that dynamically creates various kinds of OLE controls on a
worksheet.  I use code like the following:
  ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", ...
  ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", ...

I'm trying to select all sheets in my workbook.  In the past, I've always
used ActiveWorkbook.Sheets.Select.  For some reason, this time I'm getting
"Run-time error '1004'".  I've never seen this in the past.
Any other ways to select all sheets?  Anyone have an idea why it would ...

I have a array defined
Public Type fld_cis_mng
   mng_no_o As String     ' J - 10
   mng_no_n As String     ' K - 11

Whenever my ASP.NET app creates an excel file and saves it a get a shortcut
on my C drive.  The original excel file is saving in the correct place.  But
I think the recent file is what is being created on the C drive.  How can I
stop this?  Can I change where the recent files for ...