I am trying to sort for some pretty specific stuff and delete everything
else.  
Sort Column A for the letters Whse: ##  and Column B for the letters Source:
###

A question occurred to me about setting a variable to the active
workbook. If I set the variable equal to "Activeworkbook", then later
activate another workbook, does the variable now refer to the current
active workbook, or to the same workbook as when it was assigned?

I am having the worst time trying to wrap my head around this function.
I just can't seem to visualize how to do this. I have a spreadsheet
with the following:
    A     B     C     D

I can't get this to work.  Please help.  Here's my code:
Dim xl As New Spreadsheet
xl.Selection.Cells(2, 2).Activate()
xl.ActiveWindow.FreezePanes = True

Hello Everyone..
I have a dashboard workbook which works fine in Excel 2000.. The
Dashboard has lists which control the data which is being fed into the
graphs.. Based upon the level selected the data is varied and hence the

I'm having some problems with the #DIV/0! and how to get rid of it.
know why its occuring.
I have a line of code which says
Cells(9, "AF").Value = Evaluate("=SUM((AE9 / (AE9+AC9))*100)")

About ten years ago, I created a report (a one spreasheet workbook) wit
4 command buttons that ran simple macros.  Everything worked perfectly
But today, when I print the spreadsheet, those 4 buttons move all b
themselves to random locations on the spreadsheet

I'm testing an Excel application run on a Windows Server 2003 box.
Data retrieval is about 5x faster, which is what I expected.  However,
the app is bogging down adding data from an Access table using the
Cells(iRow,iCol) function in a long double loop (6000+ rows).

Hi
I have data constantly changing from using 100 to 1500 lines and when it
comes to printing, I have to constantly set the print area or drag the print
preview handles. Is there a way that a piece of code can find the last

I have a large spread sheet that i must sort.  I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and
then summing those numbers.  I am doing this because when using the
autofilter if you try and sum at the bottom of a column then ...

how can i lock selected range of cells without affecting the entire
workbook....thanks

I am looking for a random generator that will give me anywhere between 6 to
12 characters (alphanumeric) that we can use as temp passwords.  Can someone
give me direction as to what the code would be or where to find it.  Please
email me at bradley_j_mersereau@uhc.com

Well, I may have just outgrown a single processor PC.
Is there a way for VBA in Excel to take advantage of a multiprocessor
computer?
Thanks,

I'm writing code that will subtract one hour from the time that the person
types in.  If the person types only a date and not a time Excel defaults to
00:00 for the time portion.  That's the answer I want for that case only.  
How would I word an if statement to say if SASStartHE ...

I am using the following formula:
With ActiveSheet
  intMaxRow = .UsedRange.Rows.Count
  Set rngStart = .Range("E1")