MY QUESTION WAS (please see below)
Hi, I have data in coloumns  A , B and C of sheet 2 and in coloumn D
i
have formula which is "=A1&B1&C1 which make group of values which are

I need help with data consolidation. I have hardcoded file for data
consolidations as follows:
Range("B6").Select
   Selection.Consolidate Sources:=Array( _

sThis snipet of code fails in the with black while trying to set .width = 200
sub  a()
Set co = ActiveSheet.ChartObjects.Add(cw * 3, rh * 0.5, cw * 8, rh * 20)
' Name it

Following code works fine with Excel 2003 (with XLOPER instead of XLOPER12, of
course)
//====================
XLOPER12 xName;

I have a modeless useform. When the user switches to another workbook,
the userform has to be hidden, and, when the user switches back to the
workbook, the userform should be shown again. Everytime the userform
is shown, the cursor/insertion pointer should appear in textbox1.

What vba code will format a cell back to Excel's default formatting with the
default borders, clear/white background, arial 10 font, normal text, etc.?

I want Excel to determine if a cell is blank, if yes then copy the cell
above, if no then move to the next cell until another blank cell is found and
then copy the cell directly above

I have developed a basic function that will include a string value to a cell
and then format that cell's background. The string value goes in ok but the
format of the cell's background does not work. If I extract the format code
into it's own macro it updates the cell contents ...

the following macro performs only if I set one or more breakpoints in it.
If I run the macro without breakpoints I get one error that says the Data
refresment is impossible owing to the protection of some cells or graphs.
The external data are contained in the sheets A, B and C only ...

LISTING 1 below shows a range of A1:C9 where the values in column C are a
formula that finds values that are equal in column A and B. I need a way to
go down column A and B and delete any cells that are "matched" in Column C.
The trick here is once a cell is deleted in Column A ...

Hi,  I have data in sheet 2 in coloumn A to C like (please see below)
A  B    C  ------------coloumns
1 GG ST1
2 BB ST2

I am working on an addin that define an UDF following an approach
similar to
http://blogs.msdn.com/andreww/archive/2006/07/23/675939.aspx
The UDF gets listed correctly under Excel 2003 (and recognized as well

I been sent macro by one of online friend .  This macro copies entire
row from sheet1 to sheet2.  what should i do that this macro only copy
rows from cell A to cell F instead of coping entire row.  please any
body can give any suggestions or macro

After upgrading for Excel 2003 to 2007, I'm trying to solve a "can't find
library or project" error.  I can't find the "references" in 2007.  I've
downloaded the spreadsheet cross reference file but it doesn't even show
Tools>Reference.  What am I missing?

I have a problem with a filter in a macro. I recorded a macro and it gave
following code:
selection.autofilter field:=1, Criteria1:="13/12/07"
(This is date type dd/mm/yy by the way)