Hello i am hoping that you can provide some help.
I have a workbook with 2 worksheets -
Workbook A contains a record of custoemr orders - one order per row -
columns H to M contains the qty of a specifec product (each column

Just wonder anyone could advise of any code to split a file into two
before importing the files into excel....this is because the file data
has exceeded the limitation of excel(too many lines). I am looking for a
way to split a file into two(one with 30000 line of data)  while ...

I have a situation where I want to open a different workbook and go to the
next available row and paste some data there from the calling workbook.
The following code works if I single step through it but not if it runs in
real time. Why is that? Is there a better way to achieve ...

I've got several worksheets with +30.000 rows, in one column (Q:Q) I need to
fill in values based on different criteria.
For that I use Advanced Filter(s) to determine which rows should be updated
with values from an Array, SLA(). Subsequently I loop through all rows in

Greetings all:
Am fortunate enough to have 2 monitors. In order to take most advantage of
this, I like to have both my worksheet and my VBA sheet open at the same
time. Makes it much easier to make adjustments/corrections to the code.

not too sure why the attached doesn't work.
It seems like the error generated by the vlookup isn't covered by "On
Error" - the error is 1004
'====================================

I have "current month" and "Year to Date" data in columns "C" to "I"... for
each of the branches for one of our companies. I need to add a new sheet [
"All Branches"]and copy " columns C to I    from each of the branch "tabs" to
the new sheet. Therefore the data from the first ...

I have these 2 functions which let me read/write to a cell.
Sub WriteCell(mSheet, mVal, mCell)
ActiveWorkbook.Worksheets(mSheet).Range(mCell).Value = LTrim(mVal)
End Sub

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/21/2007 by susaxena

Can anyone please help me with this...
The code for a "User defined Solver"  is not working :(  and me being
new in VBA can not work out why...Many thanks
Private Sub CommandButton7_Click()

can anybody tell me what is wrong in this snippet of code ?
If search_acc.Value <> " " Then
result = search_acc.Value
Column = 23

I need some help.
Sample Data
        A        B                  C                         D            
1   | 700  | 800    | =A1/B1 (=87.5%)

I have got a data which is regularly updated by my colleagues in Excel file
which is a shared file saved in a share drive.
There are around 35 to 40 worksheet. One worksheet for each employees. It
has 9 columns. I want a macro which will import data entered in all these 35

I have some named ranges (no more than 15) in a workbook and I am assigning
their values to string variables. For some reason my named ranges
are randomly disappearing after my code runs.
The syntax in VBA looks like this:

How do I calculate the difference between two times:
11:14:56 AM
11:06:41 AM
I want to know hours, minutes and seconds between the two times shown as