scenario 1: say, if cell A1 contains the value 10,2 and cell D1 contains
value 8.
scenario 2: say, if cell A1=10, cell B2=2 and D1=8.
how can I write a macro to select the cell J2 (ie. 10,2) and place the value

Hi, I need a macro that will copy rows as follows.
I have values in Cells A1:C1, A101:C101, A201:C201 etc.....
All of the cells between 2-100, 102-200 ... are blank. I need a macro that
will copy cell A1:C1 and paste special as values below in the range A2:C100

I want to cycle through a collection and add members on the basis of whether
they exist.  For example:
Function Test(Optional M1, Optional M2, Optional M3)
Dim Group as New Collection

Is it possible to create a calender drop down as a user form, thus when
then date is select via the drop down, it is set as a value in the user
form. Similar to the date calender on webpages ?

Making an other attempt to explain this, as I think I haven't done a good job
in previous posts.  (my appologies)
I have a worksheet that containes product lists.  Some are related in that
they are part of an assembly, but appear as seperate lines.  In the case

When resizing a range, excel doesn't seem to acknowledge the new size
In this example rect is increased by 1 row and 1 column.
yet when the number of rows is asked for in the msgbox in replies with
8.

i have found this examble:
Sub HentInfo()
Dim oIE As SHDocVw.InternetExplorer
Dim sPage As String

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

I have a dataset which could have a variable number of rows on a sheet
called "Data", on the first sheet I have a template which shows all the
data for that record and in cell A1 the record number (starts at 1).
I need the Template sheet number to increase by one each time, print

I want to be able to change the size of the scroll area on a work sheet
when I run a macro. The problem is that the format for doing this is
Worksheets("Sheet2").ScrollArea = "A1:B2"
where "A1:B2" has to be a string, however i will be calculating the

I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is ...

I have written a macro that matches values in two columns and highlights the
matches.  The problem arises in a loop that is searching in one column has
no match in the other.  The code generates an error.  Any input appreciated,
code follows.

I have an excel spreadsheet that serves as staff schedule for 14 staff.  I
have a data validation list that restricts duplicate entries on the list by
highlighting both cells with red formatting.   However, I need an additional
validation rule so that if any staff is scheduled on ...

I have a template that mey get distributed throughout our company (over
15,000 employees, or there-abouts), If I can get it to work. I have a
multipage userform, and want the managers to be able to enter the employee
names/numbers in the userform (page1), and have it "store" them ...

I have a question about the FindNext coding, and how to integrate it
with my application.
The code below is what I have right now to perform a Find  when the
user enters a PO number in TextBox1 of a userform in order to view a