Is there any way to sort the displayed items in my "Items List" in this Forum
by date? There doesn't appear to be any logic whatsoever to the way they
display, but it would be most convenient to have the most recent always at
the top.

The following hides the Row and Column Headings for the activesheet. How can
it be adjusted to apply to the whole workbook
Sub HideRowAndColHeadings()
   Windows("TestBook.xls").DisplayHeadings = False

When using the For i = 1 to 10
‘Your code’
Next i
Can I define i = 1 to 10 (excluding certain values)?

I have a spreadsheet that is already very macro heavy.
I have now decided that it would be better if I had more rows at the
top for a summary portion
BUT

I have a great amount of code behind "Sheet1". I would like to create
parts.
I tried putting it into modules, but then this code doesnt work.
This is the first part of the code..

Dates seem to be giving me trouble.
In my macro process I open an excel file that is created automatically each
month in a batch process.  The file has the date for which the report was run
for printed in cell A1.   I would like my macro to check that the date

I have an Access app that uses a crystal report and exports to excel.  I was
using this function to get the standard and average deviations for a specific
range once the info was in Excel:
Sub CalcDeviations(objXLApp)

Good Morning!
Newbie here getting tired of the fight!  I'm having a problem with  
attempting to offset 1 cell to the right.  
I've created a Loop Until statement based on a selectionchange, with If..

I'm drafting a macro by which I want to repeat at intervals of 59 secs
another macro 'TimedOut' so have:
Application.OnTime Now + TimeValue("00:00:59"), "TimedOut"
which works fine.  Except even if the worksheet is closed, it reloads

This is a scheduling routine. I have a list of names in one column to which I
assign a random number, in an adjacent column. Once the random numbers are
assigned, I sort the two columns together, by the random numbers, to
randomize the list of names.

Hello,
I am looking for a good way to capture the YYMM of the last month as a
string.  
My macro runs a monthly process and I would like it to automatically save to

Okay.....don't laugh.  I know virtually nothing about VBA, so go easy
on me........
I've been asked to create an "application", 95% of which is pure
Excel:  formulas, functions and the like.  The remaining 5% is stuff

is it possible to find next empty row and enter data into the next row??

I am working on a macro to filter out a column in Excel 2003. but i am
facing a problem in the Custom option of Auto filter, it can check for only 2
values using And / Or
   Selection.AutoFilter Field:=5, Criteria1:="=a",

The help in my MS VB Editor help doesn't bring any MS VB Language Reference
Content so can someone help me on where can I get help on commands I can use
to manipulate arrays on my Excel macros?
Thanks in advance,