I have a macro which loops till a criteria is met. I then want it to insert a
formulae using the two cells immediately to the left of the active cell. Then
it will continue to loop until the criteria is met again and the formula
again inserted. How can I get the macro to ...

I have been writing code but seem to be doing the same over and over again,
what I need to do is,  have a macro look through 16 sheets called "a","b"
etc and in column g to lookup any value greater than 0 and when it finds one
to copy it to sheet13 give also the value in column c ...

I need to have my macro execute the command ActiveWorkbook.SaveAs in a fully
automated mode.  I need to have the macro suppress any user dialog boxes.
If the file already exists, I want the preogram to overwrite any existing
file with the same name.

I have all these tables in excel which needs to copied and pasted into
word in a specific space. The problem is i have to produce 300+
documents with different figures. The figures change based on a
autofilter on the table.

  I am using VBA in excel to create a program that queries a database and
fills out excel spreadsheets.  I have made a list of Classes that I use and
need to be able to use the same classes in several different projects.  
Earlier I asked a question about how to create a ...

I use WIN98 and Excel. I need to do the following sum on a
worksheet\spreadsheet
YEAR ONE
My pensions produce an income of A

I am trying to determine how to write a formula that allows me to calculate
YTD earnings but I cannot figure how to get the year-to-date to work. I know
how to get the number of weeks from one date to another (for example
8/1/05-4/12/06 = 255 days or 36.43 weeks). My issue is ...

i have a template made and working mostly fine but i need two things and
unfortunately i do not know codes and stuff.
on the first three tabs (sheet1, sheet2, sheet3), i do not want them to
print - at all;  

This is my problem:
I want to loop through all the files in a folder, and delete all files that
are not called "ABC_QUALITY_RATE.xls"
I think i'm close, but he's not very happy with the "Kill

Hi Wizards,
I need a simple code needed for the example below:
Range1 (approx 375)
30-01-2006   xx1   220

I have a spreadsheet having two ranges (1) deduction range (2) remittance range
since remittance is not made correctly I need to match remitance to
deduction range (FIFO method) and insert a row in the deduction range, if
required. sample as follows. ie c1 the first remittance is ...

I would like to find a method to place a chart at a specific cell location
within a worksheet.  I am adding a chart using data within the spreadsheet
and need to place the chart next to the data.  I can't seem to find a method.
The code I am using to add the sheet is as follows ...

I would like to open a file but the path name should be given in the
input box
fox example:
Workbooks.Open Filename:="\\10.10.10.4\x\y\z\a\PRODUCTION REPORT.xls"

I have written an excel addin that builds reports on a workbook when the
user clicks on a customized toolbar button (that calls a macro).    In
addition to that, I also need to be able to run that macro automatically at
6am every morning through a vb application that would always ...

When a macro in my spreadsheet is run on another PC the user gets the
message, "Run-time error, method 'paste' of object - worksheet failed." When
it is run on my PC it works fine. Can anyone explain this? Thanks in advance.