Excel 2003 SP3
Winows XP Pro SP2
I wrote some [bad] code that was "hiding" a value in cell A65536.  When I
realized this was causing tiny slider bars and also causing unusually large

I use a label macro to put labels on chart points ..
Sometimes the data comes in as dates when the text is 4-17.  Even if I
format it as text the point labels are dates.  How do I get around this.
windows 2000

I'm having trouble converting a macro to late bound code so I can run it in
Access. I recorded the macro in Excel and got the following code
Columns("A:C").Select
Selection.Sort Key1:=Range("C2"), Order1:=xlDescending, Header:=xlGuess, _

Is it possible to apply a border around groups of data.  
For example, give the the sample sheet below, a border would surround the
groups of fruit.  Borders would highlight the Apple, Orange, and Pear
sections.

When I use "ActiveWorkbook.SaveAs" in the following code I lose focus from
the macro it originated from .
'=========
With ActiveSheet

I have 2 sheets. There are one string like E1234 and one date on each sheets in one row...
E1234    11/11/2007
E5846    12/10/2007
The strings are the same in the two sheets in the same columns but they are in different rows related to the other sheet. My aim is: if one date has ...

I have the following code.
The following sub is written for deleting a worksheet that has its
name as 0. Code works but I dont get the desired result.
Sub test1()

I am needing to search column G on the "Master" sheet for certain states
starting at row 3.  If if finds the correct state, say AR, then I need it to
copy that entire row and paste it into another worksheet.  Here is the code I
am working with:

I have some data that is listed in the lower portion of a worksheet
(rows 201+) and want to grab it based on user input into a cell. I
also want to calculate an average of that data.
ie

Initially I have Sheet1(Sheet3). Later I rename the Sheet 3. Let's
assume it becomes Sheet1(AAA). The name changes periodically. So, I
would like to select it using the sheet's index. What would be the
macro/syntax for this? Thanks

Hi, i'm new at using fortran and vba, and i'm trying to covert an old
progran that i found to a dll, so i can pul it from microsft execel,
with the elp of vba.
but i'm having some problens and got lost on how to do this, so i

I need help with an if then else macro
If Sheets("data Worksheet").Range("H26") > 0 Then Range("H26").Select Else
Range("BA1").Select
    Application.CutCopyMode = False

Modifying every formula in the code given below is too time-consuming.
Is there any way to simplify this code? I would really appreciate if
anyone can help me in this. Thanks
   Case "Sheet3"

I can not find "movable" property for the form. So, how can i prevent user
from moving it around?
Thanks

How do you or can you convert or save an MS Project 2007 file to an Excel
2003 file?