how i can write a macro to sort colume E sort from Ato z

Few weeks back i had posted query related to reading data from excel having
pivot table(reference to the pivot table not know). The solution was:
Sub CreatePivot()
   Dim pvtCache As PivotCache

Hi all, I wonder if you could offer some advice, please.
I am generating a number of worksheets within a workbook.  I then want to
group some of them and copy them to another workbook.  The names of the
worksheets I am interested in all end in "DWM".

I've got a marco that automatically saves the file to include the quote and
business name. I.e. 1000 ACME.xls. I also need to add the current date
without formatting. I.e. 1000 (quote number) 160507(date) ACME (business
name).xls How can I get the date in this format for the ...

There is nothing wrong with the following piece of code, it can be executed
in many PCs I tested it w/office 2003 and xp:
   With Application.FileSearch
        .LookIn = ThisWorkbook.Path

I am receiving the error "File Error Data May Have Been Lost".  No data is
being lost.  Is there a way to supress this message.  
The error occurs when the file is opened but does not appear everytime the
file is opened.  When it appears it may come once, or multiple times in

I need your help, please
Anyone know where I can download a VB macro that will URL encode a
string?
Thanks in advance for any help

I have a UserForm with a single Control.  It's a TreeView Control from
Microsoft Common Controls 6.0 (MSCOMCTL.OCX).  When I call the UserForm's
Show Method, the Form shows with the Window Borders highlighted like it's got
focus but the TreeView Control has no Node highlighted ...

I'm getting intermittent "Runtime error '16': Expression too complex"
using the following code.  It seems like if I step it through slowly,
it'll work for a while.  What's wrong?  I'm using Excel 11.8033.8036
with VBA 6.4.9972 if that matters, on Server 2003.

Hello experts,
I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is

I have a worksheet that is used for data entry, then its puts that in a other
report spread sheets well, a few of the cells will rarely be changed.  I
would like a message box to pop up and Ask if the user is sure they want to
change the information in the cell.  Than have the ...

Need some help...  I have a form with 20 OptionButtons and want to update
the Captions during initialization from a list on a worksheet.  Simple
concatenating "OptionButton & x" does not seem to work to step through a
list.  Thanks in advance.  RobC

Does anyone know how to introduce a time delay into VBA macros?  I created a
macro that runs an application on about 15 different worksheets.  I want to
be able to have the macro pause between worksheets, to allow this application
to have enough time to download on every sheet.  ...

I want to do other types of SQL commands in an EXCEL macro besides standard
"select" queries. In particular, I'd like to do a "truncate table" , and also
an "Insert" and an "Update". I recorded a macro to do a "select", thinking I
would then just edit the "select" statement to do ...

I am preparing a formula which needs the address of the first cell located
above the active cell that contains information .  The key strokes would
normally be "=" then "ctrl + {up}" then "{enter}".  What macro language would
achieve this result.