I'm not very good at programming. I have one column with values as such:
(x1,y1,x2,y2,x3,y3.......) They alternate from x to y. How can I take
this column and make two columns, one for x and another for y? It is
alot of data, so manual copy and paste is out of the question. Please

When I try this code, all of rows 2 through rows 8 on the worksheet
"Test" are filtered and no longer visible.  
I would have expected rows 3 through 4 and 6 through 7 to be filtered.
Can someone tell me what I am doping incorrectly?

I just upgraded from Office 2K to Office 2K3.  I am getting the following
errors when I start Excel.  I can't find where I set these locations in the
past.  Any help would be appreciated.

I need help on this
I have a data like this for 5 columns.
ColA    ColB
SHM    SHMP

Danny Fishers Music Magic, GORBYDF@AOL.COM
http://www.craigslist.org/eby/for/162729880.html (925) 447-6325, ,
Livermore  (925) 980-4182 MAKES DEATH THREATS  THIS GUY is a FRAUD and
is on  Drugs 24/7 and he cyberstalking , harassing, stalker and more

how can I get the file size of an file?
I would like to run through many folders and list all files that are under
30k. Can this be done easily in vba?
Thanks

Guys
I need to copy data from one excel file to other. Am doing this in
asp.net with c# as backend code. Do I need to two excel Application
objects? No matter if I use two excel objects or one, I am ending up

In the following example I'd like to do something a little different
with the list index and I'm not sure how to go about it.
In the Private Sub Userform_Initialize() routine I'd like to see only
the listing for specific records, let's say in column 2 I have listed

I have a series of workbooks containing 2 or more Pivot Tables.  Each table
refreshes from an external source over an ODBC connection.  The user is
prompted for username/password for each table refresh.  I'd like to have a
UserForm capture the username/password once and then code ...

I had a problem with a #DIV/0! error and was given some code here that
works very well on the cell it is aimed at, but I was wondering how I
could tweak it so that it would work across a range.
The code is this

I am looking for a way to have excel open and compile separate
worksheets for different values in column A, in a large list of data
(about 6000 lines worth).
There are about 10 possible values for column A, and I need a separate

I want to remind users of a workbook that they need to fill in a last updated
cell if they have made any amendments to the sheet.
Is there a way I can get a message to pop up when they go to save the
document so they have to input the 'Last Updated' date in the relevant column

I have an array of 40 items.
I need to go down a column of 600 cells and for each cell I need to
test whether the cell.value is equel to any of the items in the array.
At present this is really slow as my code is doing a loop of 40, 600

I am trying to run a Benford's law analysis.  I get a run time error 13 -
type mismatch at the following point of the macro:
For Colcells = 1 To Row
x = Left(Cells(Colcells,Step), 2)

The issue I am having is easily reproducible I think (I'm using Office
2003):
1.  Create two files: Book1.xls, and Book2.xls.
2.  In Book1.xls, add any code to the Workbook_Deactivate event. I've