Can anyone tell me what run-time error 1004: Application-defined or
object-defined error is?
I have inherited an excel workbook that has some macros in that give me this
message and I don't really know why it is happening.

I have a column chart in Excel. I want to change the data label font
color for one data point. If I right-click on the data point, I can
change the color or the column or the border but not the label.
Any help would be appreciated. Thank you!

I have a excel spreadsheet that is saved as a read-only file. My work
area has access to this file. When one co-worker opens the file, the
row height is different from everyone elses. Any suggestions why this
would happen or how to fix?

How can I group a few columns together?
Suppose I group Column 1 , Coulumn2, ...., Column6 as One and
similarly  I group Column 7, Coulmn 8, ....., Column10 as Two  and I
put One and Two as heading in top of columns .

I would like to make a master list in excel for all of my other worksheets to
be able to access to save myself a bunch of typing time. Example, if i have
in my master list
Column A      Column B       Column C

I have a list of data that ranges from one cell in column A to over 400 cells
(this can change as well) in column A.
At the moment I have to manually cut and paste the first 50 cell from column
A to Column B, then manually cut and paste the next 50 from column A to

Total novice here, so sorry if i annoy anyone, anyhow my work sheet
won't allow me to drag and fill my formula? Could do it the other day,
but just returns o's now. I have been to my tool bar but dont see any
options to correct anything. Any suggestions?

I have having an input sheet(Input) and use macro to add data to
another sheet(PartsData)
The macro is as below:
Sub UpdateLogWorksheet()

One can use SEARCH() or FIND() to find a string within another.  And, if you
wanted to find the first few, you can nest the calls and it probably works
ok.  But, this has its limits.  Lets say you wanted to find the 10th
occurance of a particular string within a string, now the ...

l had received  one cd from my department. when  l tried to print l got a
problem.there  was  two  page in one sheet. that mean 50% one page. l want  
one page for one sheet  but l do not know  how to do it. could anyone
understand me and please help me

I've been using Excel 2007 for a few weeks now and I've noticed that
the 'Record Macro' functionality is not so complete anymore.
For example if you record a macro when adding a picture to your
sheet,resizing & moving it, then saving your sheet.

I am find an error in this statement, and the error shown is
"Application defined error or object defined error"
ActiveSheet.Range(Chr(r + 64 + 0) & c).Formula = "=index(" & Chr(11 +
64) & "2:" & Chr(11 + 64) & (max_date) & ",match(" & Chr(1 + 64) & r &

good evening,
In my rows I have a column in my worksheet that has the folowing
information and meaning:
D21="PAYE 2004"

One workbook has 4 sheets size of file is approxiamtly 1 MB
after erasing 3 sheets and saving the size of file with one sheet (tables-1
left) is 744 KB only
I then copy that sheet (tables-1) to another workbook that has other sheets

I am copy/paste data from emails to excel. The font in the email doesn't fit
the cells.
I get a clip board asking me if I want to match the destionation, I have to
click on that I do everytime I input the data. Any help?? Thanks