I have data like the following.
6.00 x 12.00 x 24.00 CRS
I would like to split out the last part (CRS) into another cell.  There is
always a space before the data to split, but the rest may or may not have

hello, I'll explain my problem:
In a workbook for daily reports each day a new worksheet is made. For day 1
the sheet is named " 1", for day 2 "2" etc.
Now I add a worksheet which I call "calculation". In this worksheet I have a

How do i write a macro to autofill Country USA in column b  until the end of
the cell with no data. Assuming i have more than 1,000 record. So whenever i
run the macro, it will automatically populate.
Thanks

i want to trigger a macro just after i open my workbook in EXCEL with
the condition that if value of cell B1 is equal to todays date trigger
the macro and written the below code.
Private Sub Workbook_Open()

I have a worksheet that has two events, shown below:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
 If Not StartEvent Then Exit Sub

I've written an XML web service to check the version of the VBA in an
Excel file against the version stored in the database.  If the version
in the database is newer, the user is asked if they want to update
their file.  If so, the web service returns the stored code from a

I would like to be able to list (identify) all cells in the source workbook
that have link to other workbooks ?
ex:
SourceWorkbook cell A1 link to c:\Data1.xls cell G9

Hi all, This is probably so simple but it is eluding me...
Column "AL" has a variable number of values in it and i need to get the
total and paste only the total in the cell below the last used cell.
Could somebody please help me out of my misery... :-0)

I am using two userforms ("ufZipCodeMarket" and "ufRepInfo") and want to
populate the textbox ("tbZipCode2") on userform("ufRepInfo") by entering a
value into the textbox ("tbZipCode") on userform ("ufZipCodeMarket") and
pressing a command button ("cbFind") on that userform.  ...

I would like an Excel user to be able to go to a cell, and then paste the
file name ,(preferably without the full path, but that is not an absolute
need,) into the  cell. The file will be in the same folder, and will be a
Word, Visio or Powerpoint file.

Hi, is there a way to programmatically copy and paste (into a text
file, say) all Subs, Functions etc from all Modules in an Excel
workbook?
This is so I can use this as project documentation. I have tried

I am very new at VBA, and just got a project that requires adding a
combo box to a "FORM" in VBA. I have this long list of ppl's names,
and hoping to some how organize it into a drop down list. I think I
should either use combo box or list box. I know how to do it with a

I have a sheet of orders and i have recently redesigned the sheet to contain
lists. I wanted my employess to be able to search easily, and without much
excel knowledge i came up with this. However, as i have about 23 columns of
data it has become difficult once somebody has ...

I have recorded almost what I need and hoped you guys here would be able to
help me. This Macro will
Drill down into 8 specifically placed pivot tables on a single worksheet,
and save the individual files to c:\test.csv

Working overtime, there are two options. Get extra money
or have some extra days off later.
The table below shows Overtime worked in May.
Line    Date    Hrs