Here's my problem.
I have an Excel XLA which is installed on multiple workstations.
The XLA contains VBA code to create a new workbook and import a report text
file into it and format it nicely.

Here's my code:
Private Sub cbAddContents_Click()
Dim ind As Integer
Dim tot_items As Integer

Cell A displays text based on an IF statement.  for example: "Water"
I then have a worksheet titled "Water" and would like cell B to use the text
displayed in Cell A ("Water") to look at a cell reference on the "Water"
worksheet.

I'm trying to use either a macro or conditional formatting to compare two
sets of data. the two sets of data each have 3 corresponding columns and i
need to separate out the rows which occur in both andj the rows that occur in
just one set of data. i have found a post which does ...

how do i know whether a particular array contains any elements?
thanks

I'm constructing a sheet to aid 5 departments handle backlogs.
The raw data is given to us from a database, in an excel format, once
every night.
I'd like to split the raw data from tab1 to tab2-6, depending on

Have a question.. I'm currently working on a project that's all about
updating excel documents with a current one through a program. since we're
dealing with spreadsheets that have a huge number of cells (some more than
702 sheets) I have to do everything through the program to ...

I have 2 combobox with data inside.
When I select an item (eg. x) from ComboBox1, I require ComboBox2 to
contain/filter only related items to x.
Can I confirm that I couldn't use any existing Excel functions to do that?

I have a a piece of code that works well in VBA
The same code works well in VB6 apart the
"fill.Fill.OneColorGradient ...." line
xlApp.ActiveChart.SeriesCollection(1).Select

I'm trying to create a macro in Excel 2002 which will select certain rows of
a worksheet using the Autofilter capability.  The (non-contiguous) rows will
then be copied to another worksheet within the file. The number of rows
selected will range from zero on up.  Since the number ...

Is there a VBA code were i can print one worksheet multiple times and have a
file no. print in sequential order each time i print the worksheet.
ie. print 10 copies of the worksheet and the file no. will be 000001 -
000010. And the next time I print 10 copies the file no. will be ...

I'm trying to copy the contents of a named range on one worksheet over
to another named range on another worksheet, using Paste Special macro
code.  However, when I execute the macro, it seems to lose the
definition of the target named range.

Hi , could somebody  explain to me this functions  behavior and the
parameters ?
Regards

I am trying to create a new more efficient form for some employees but really
struggling getting to grips with the code.
My main worksheet contains a table of costs and various lists that are
manually entered by the user

If I have made any changes to the personal.xls and have not saved it
in Visual Basic and I lock the computer,  it is the active window when
I unlock the computer.  Even if it is not the active window when I
lock the computer.  I am using Windows XP with Office 2003.