We currently have a spreadsheet that pulls information out of the cells of
other worksheets.  VBA was not used to build this spreadsheet and the creator
has long since left the company.
The spreadsheet broke and we can't figure out how to fix it, so I would like

i need to confine the content of column j to 2 digitts
i want to limit the column < 100, and also if i enter 5 should become
05
the limits can be done in data validation,

I have a PivotTable:
1st col:                      2nd col:
Dates(Row fields)      Sales(Data fields)
01.01.08                   100            

I have written a macro that shows the Save As dialogue box, but I'd like to
add code that closes a workbook if the user selects "cancel".
Can anyone help?

This works fine:
If IsEmpty(cll.Offset(0, 1)) Then cll.Offset(0, 1).Interior.ColorIndex = 6 _
Else: cll.Offset(0, 1).Interior.ColorIndex = xlNone
I want to do the same thing but for a range of cells in the row (from colum

This may be an out of place question so I appologize.  But the best book for
teaching beggining VBA that I know of is Excel 2000 in 21 Days.  It is no
longer available in book form  It does a great d]job of actually building
prgramgs not just deicussing sub routines.  Are there ...

I am not sure, if any one else has faced the same problem. Please
advise.
Issue:
I have formatted cell "D1" as Date with Category as "14/03/01" and

I am basically trying to get data from an SQL database, you can see my code
below:
Sub SPICEdownload_indexvalue()
'On Error GoTo datapullerr

I found this tiny macro on the web and I was trying to modify it for my
purposes, which basically includes finding and selecting cells with the word
‘Total’ and placing a boarder around cells in that same row, STARTING one
column to the right and six columns to the right of that. ...

We have a sliding scale overhead rate based on the following table.  I have
created a function which takes its place.  However, now I need to back into
the overhead from the subtotal.  I could use “Solver” and solve for subtotal,
but have over 800 lines.  Is there code I could ...

I'm using Visual Studio/Visual Basic which is very similiar to VBA.  I need
for my program to recognize when a cell has 8 alphanumeric characters in
column A, and if it doesn't have 8 alphanumeric characters to delete the
entire row.  Any ideas on how to do this?  Thanks in ...

I often use VBA to open files that stay in memory.  I'd like to update the
recent-files list sometimes when I do this.  How is that possible?

hello i am triing to group these numbers below, but i do not want the total
to exceed 168. i need to know how many pieces that are 168 in length it will
take. i would imagine it will take some vba to conduct this and i am fine
with this.

Got a problem with my 2003 macro inside excel 2007.
When  I start that macro I get the error message below (translated from
german):
"error-No.: 1004

I have an Excel application that is used by manys users with Excel
versions varying from Excel 2000 to Excel 2007. WIth the release of
Excel 2007, you must Digitally sign the project to enable macros.
However, Microsoft has a known bug that results in the users being