RANDOM Sort based on criteria

**MarvinP** · 07-01-2011, 11:56 PM

http://support.microsoft.com/kb/177828
http://support.microsoft.com/kb/213672 ??

Keep trying different stuff. Make sure you are not half way entering data in a cell and then press the button.
Can you see your Visual Basic Editor and read the code I've written?

**MarvinP** · 07-01-2011, 11:59 PM

Hi Technot -
Tell me you are using Microsoft Excel and Not Micorosft Access. What program are you using?
I just noticed you posted this question on the Access Forum.

**Technot** · 07-02-2011, 12:41 AM

It's from Microsoft Office. It was suppose to be on Programming program.

Looks like we are at a dead end. I have spent a entire week trying to figure out this mess. I appreciate your help, As I said befor all I know how to do is put numbers in a spreadsheet. I retired as an accountant and budget executive and never really had hands on.

Thanks again,

**Technot** · 07-02-2011, 12:42 AM

I can read the code you wrote.

**Technot** · 07-02-2011, 12:49 AM

I can't access either version you sent, Did you do something to delete it?

**MarvinP** · 07-02-2011, 01:00 AM

Hi,

I think it must be your version of Excel or a setting you have. Do you have someone with Excel 2007 or better and a net connection that can download my attachment and run it. I've run out of ideas on how your version won't work with my code. I hope you are running Excel and not Access ... I'm clueless on this one. I wish I could sit down at your computer and figure it out.

**Technot** · 07-02-2011, 01:35 PM

I will look at it on my wife's laptop. She has a newer version. I have a friend who has "cleaned" out my computer several times. I am going to call him and see if he can give me some time.

**Technot** · 07-02-2011, 02:23 PM

I tried my wife's computer and had the same results.

**MarvinP** · 07-02-2011, 02:24 PM

DARN!! Now off to your friend with a newer version of Excel?

**Technot** · 07-02-2011, 06:42 PM

I have been looking on the internet for a vendor that has an online update from 2003 to either 2007or 2010. I understand the 2003 version is quite cheap now with the release of the 2010 version. My wife's version was 2003 also. Hopefully thats all I need to do but as you said there is probably a setting that is not quite right.