I wanto to complain 2 XL sheets.
Dat is the same but columns are layout in a different order.
Column headings are the same.
All tools thatI found in the knowledge base are based on same layout

I am tring to clean up a report that is pulled in a off a propritary program
in my company. The format comes in as all "General" cell format. I have
cleaned up some stuff already but am having a hard time getting the below to
work properly.

I am trying the following but getting error messages, please help
Sub AddModule()
Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_StdModule)

Excel 2007 table ranges do not work in multilingual configurations. The
solution I am developing involves external data, however, I managed to
isolate the problem so that it can be reproduced in a few easy steps:
1- Create an empty workbook.

Using VBA, I populated a two dimensional array with values. I want use
various "rows" and "columns" of the array as inputs into an Excel
function. For example:
Dim arr As Variant

I have an adding which includes adding a new workbook. One of the guys using
my addin gets stuck as the adding of a new workbook causes Excel to launch a
modal dialog via another addin he has installed. How can I trap this, and how
can i talk to this other dialog to close it?

My files have the same data
ie File 1
Record Num Value Year.....
101                 12     2007

Hello,
I want to receive the worksheet names for random Excel sheets, the below
mentioned solution works for most excel sheet but with the most important one
I get too many excel sheets in this format

Gurus,
I have a procedure to delete all existing modules from a chosen
workbook if the type of the component is not vbext_ct_Document. The
extract of the code is here:

is there a way to assign copy and paste to a function key or some other key
combination?
i tired this and it didn't work, it still bring up the help pane.
 Application.OnKey "^{F1}", "^{C}"

I have some code to copy a certain worksheet within a workbook to
another workbook:
...
   MYSHEET.Copy

I need to define a loan repayment schedule using PMT, IPMT and PPMT
functions which i fully understand. However, based on the number of
installments I need to define the corresponding number rows with the
sequential numbers.

I have a workbook with the following code in a sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo errHandler
Application.EnableEvents = False

I can't change a document in Excel that keeps printing at about 25%
scale. In print preview it appears to fill the page. I have changed
the size of the cells to make shure it will fit on one page. But when
I print it only prints a small graph in the bottom left corner. I

I need help....
I have a worksheet which looks like this...
StoreNo--->      201          202         203
Week 1              X