I want to be able to insert a picture in a variety of cells (each cell
is a range object in the object arrayofRanges). Can someone help me
with where I am going wrong?  I have a feeling I dont get the whole set
for pictures right.

I have two seperate excel files (file1: inventory.xls, file2:order.xls
each with two columns (col a: part #, col b: quantity).  Using the par
# from order.xls i would like to search inventory.xls for the same par
# and add/subtract the respective numeric quantities.

I keep getting the runtime error on the following piece of code.  
"Run-Time Error 1004: Select Method of Range class Failed"
Code
-------------------

Hi,
I have a lot of small changes I make in a standardized form (an excel
spreadsheet).  The forms are stored in multiple locations on the network but
I have a list in a worksheet that has hyperlinks to every form.   I am trying

Im very new and lack much knowledge about what im doing, so please b
kind and very simple.
im attempting to make a form for submittals. I am using a drop dow
menu for company names that these submittals will be sent to. and

Here is the statement I am using.
For Each ce In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
   ce.Offset(0, 1) = WorksheetFunction.CountIf(Range("k:k"), ce.Value)
Next ce

Is there a way to invoke a worksheet event procedure using some kind of
key combination?
Specificly, I would like to assign some key combination that will
invoke the "worksheet_beforerightclick" event, whithout using the

First, please pardon my absolute inability to properly explain what I am
about to ask. I know next to nothing (or less) about programming.
I am trying to find out if I can make one cell do conditional formatting,
based on five different sets of criteria.  Currently, it is set at ...

I use this code to enter the data from a Userform into the next empty row on
a sheet:
iRow = ws.Cells(Rows.Count, 1) _
 .End(xlUp).Offset(1, 0).Row

Hi, I have been searching hi and low for a solution to this and beginning to
think it may not be possible, please help you are my last hope.
I have a worksheet that has a 12 month calendar on it formatted as below:
        January

Hi, I have a work sheet with a chart and tables. I want to print this sheet
40 times, but each copy will have changed value in one box (add 1 to the S2,
so it will rise from 1 to 40) Is there a possibility how to create a command,
which will print this sheet with changing value ...

I am using Excel 2003. My status bar is displaying "FIX". This is being
displayed at the right hand side bottom of the screen. I have tried the
following:
1. Remove all the macros

Hi everyone,
My main question is: how do I populate a combobox located in a userfor
with items from an array?  I thought I would use .AddItem like I would
listbox, but it simply will not populate.  Here is the code:

I'm developing an Excel VBA procedure and I need some support.
I believe I'm doing a very basic error...
WHAT AM I DOING?
I'm opening an excel workbook and link it to a workbook variable type,

First, please pardon my absolute inability to properly explain what I am
about to ask. I know next to nothing (or less) about programming.
I am trying to find out if I can make one cell do conditional formatting,
based on five different sets of criteria.  Currently, it is set at ...