Spreadsheet Page Blog Comments

Comment on: Excel-related RSS Feeds (by Doug Glancy)

Doug Glancy — 2012-02-11T16:02:40-07:00

Thanks!

Comment on: How To Be Employable (by Doug Glancy)

Doug Glancy — 2012-02-11T15:58:37-07:00

"All you need to do is to buy a book by Walkenbach and work your way through from beginning to end." I said virtually the same thing last week in response to somebody asking about the best Excel tutorial websites. There are many great Excel sites out there, but I don't know of any that pack the punch of one of those 800-page babies.

Comment on: How To Be Employable (by Alex)

Alex — 2011-11-20T00:01:00-07:00

Really?I'm not sure if someone is good at spreadsheet then he will not be got rid of.

Comment on: How To Be Employable (by Mike Woodhouse)

Mike Woodhouse — 2011-11-16T03:31:28-07:00

For heaven's sake, don't spread this around - you'll make it harder for the Excel insiders who already know!

In general, I've found that almost everyone is impressed to a quite inappropriate degree if you (a) can use array formulae to condense oceans of Excel real-estate (b) know what a class is and how to use one in VBA and (c) can customize the Excel interface - in any way at all. All three together and you should never be out of work for long.

Comment on: How To Be Employable (by Rob Bruce)

Rob Bruce — 2011-11-15T15:30:18-07:00

Not only this, but if you make your speadsheets sufficiently impenetrable, you'll be literally irreplaceable: They won't ever dare get rid of you. Until your wizardry brings the whole company crashing down, that is.

Comment on: More On Office 2007 Colors (by ES)

ES — 2011-11-14T15:13:08-07:00

Kaspersky PURE

Malware on these links

Comment on: How Fast Is Your System? (by xl)

xl — 2011-11-12T11:36:39-07:00

*ultra low VOLTAGE

Comment on: How Fast Is Your System? (by xl)

xl — 2011-11-12T11:35:49-07:00

This is weird - my core i7 2670QM with Excel 2010 64bit made test in 19 seconds :x...my next notebook with ultra low volatege processor (SU9400 1,4GHz) did the test in 14 seconds...what am I missing?

Comment on: More On Office 2007 Colors (by Jon Peltier)

Jon Peltier — 2011-11-02T10:22:23-07:00

Those links to Tony's articles have changed:
http://proofficedev.org/blog/2007/08/colours-in-word-2007-part-1/
http://proofficedev.org/blog/2007/10/colours-in-word-2007-part-2/

Comment on: Hiding & Unhiding With Shortcut Keys (by fonthiller)

fonthiller — 2011-11-01T10:46:19-07:00

This cured it (running Win7 & Excel 2010):

http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010

Comment on: Excel Champ (by James)

James — 2011-10-27T06:02:53-07:00

Hi John,

You are right !!!

Will somebody ever get his hands on the test ???

It would be nice to share it with the Excel community ...

Cheers

Comment on: How Fast Is Your System? (by Michael Dawley)

Michael Dawley — 2011-10-25T09:27:40-07:00

5.257813 seconds

Intel Core i5 M520 @ 2.40GHz 4.00 GB 64-bit Windows 7

Comment on: How Many Books? (by Mike Alexander)

Mike Alexander — 2011-10-18T09:24:25-07:00

You have definately earned your place in the Tree Killing hall of fame.

Comment on: How Fast Is Your System? (by Rick)

Rick — 2011-08-12T13:30:37-07:00

Both tested with original code

Lenovo Desktop
Windows XP Professional, Excel 2007
32-bits, Intel Core 2Duo E7500 2,93Ghz, 2GB RAM
Time: 6,91s

Toshiba Satellite Notebook
Windows Vista Home Premium, Excel 2007
64-bits, Intel Core 2Duo T6500 2,1Ghz, 4GB RAM
Time: 9,72s

Comment on: Excel Champ (by ross)

ross — 2011-08-09T04:49:22-07:00

this is depressing! a competition to see who is the fastest at using Excel, for god sake!

Comment on: Bad Charts On Wikipedia (by Doug Jenkins)

Doug Jenkins — 2011-07-11T16:43:18-07:00

Wikipedia has now replaced the pie chart with a bar chart.

Now I know that this is heresy of the worst kind, but I preferred the pie chart. It provides information visually that is not easily available from the bart chart. For instance, it shows that the 9 biggest states have about 50% of the total population. It also displays the relationship of each state's population to the total more clearly. Sure, it doesn't display the data for the small states clearly, but that's what the table is for.

I don't see anything wrong with the table either.

Comment on: Enhanced Data Form Crashing? (by Christopher)

Christopher — 2011-07-08T20:57:59-07:00

Hello John.

I have the Office 2010 32-bit running Windows 7 Ultimate on one machine and the 2010 64-bit running Windows 7 Ultimate on a similar machine. Office runs better in the 32-bit version as far as I have been able to tell with my testing.

It is funny, the Dell with the Dual-Quad core processors and a whopping 32-gigs of ram underperforms the Dell with a single Quad core processor with 18-gigs of ram. The machine with the single quad-core has the 32-bit version of Office. Both running the I7 processor.

When I bought Office 2010 I thought that the 64-bit version would perform much better. I should have done my research. Zack told me this months after I made my purchase. I still do not understand why this is the case.

Can someone explain this to me?

Christopher

Comment on: Bad Charts On Wikipedia (by Andrew)

Andrew — 2011-07-05T15:09:16-07:00

Chip, your comment is hilarious

I think the table below the chart is shocking too.

John, are you going to offer a better solution for us?

Comment on: Bad Charts On Wikipedia (by chip)

chip — 2011-06-29T12:37:11-07:00

Why? What's wrong with that chart? It tells me that I live in a large, purple state, while you live in a state so small that I can't locate it in the tiny little slices. What more would I need to know?

Comment on: Enhanced Data Form Crashing? (by John Walkenbach)

John Walkenbach — 2011-06-21T18:18:35-07:00

Yeah Ed, it's a simple little change to make it work with 64-bit Excel. So far, nobody has requested it, and I'm too lazy to do it on my own.

I really hate these kinds of problems that can't easily be reproduced.

Comment on: Enhanced Data Form Crashing? (by Ed Ferrero)

Ed Ferrero — 2011-06-21T17:56:00-07:00

Hi John,

Just tested with Excel 2007. Works fine.

Won't work with Excel 2010 - 64 bit, but then you already know that.

Comment on: PUP Sale Phase II: Details (by Vicki Baker)

Vicki Baker — 2011-06-08T15:08:33-07:00

Arrrrggghh! I missed the sale by a day!!!

Comment on: Analyzing Free Money With A Pivot Table (by Mark Rosenkrantz)

Mark Rosenkrantz — 2011-06-07T10:47:07-07:00

But you probably sell your books in many other ways !!!

Comment on: PUP Sale Phase II (by BrianR)

BrianR — 2011-06-03T04:41:58-07:00

Many thanks!

Comment on: Annoying Date Entry Behavior (by Philip Last)

Philip Last — 2011-05-26T03:18:56-07:00

Regarding the average 1st date, you could convert the date to the number of elapsed days since the 1st day of the year and average that result? That would then give you an average you could add to the first date of the year to get the average date you expect something. If x is the date you saw the first robin then Days = Value("01/01/" & YEAR(x))- x

Averaging this will give you the day the event has happened over time. To see what day that equates to this year then INT(AverageDays) + DateValue("01/01/" & YEAR(today())

Comment on: Annoying Date Entry Behavior (by M. Simms)

M. Simms — 2011-05-19T09:47:48-07:00

Yes. CDate() does just that when the year is missing from the character string.

Comment on: Annoying Date Entry Behavior (by John Walkenbach)

John Walkenbach — 2011-05-18T19:10:19-07:00

The solution is to enter the year along with the month and day. Like this:

3/10/2011

Do you really expect Excel to figure out what year you're entering if you don't tell it?

Comment on: Annoying Date Entry Behavior (by Bob Jumpman)

Bob Jumpman — 2011-05-18T18:35:37-07:00

My problem is similar to aphrodaia's mentioned above. I would like to use month/day without the year.

I want to find the average 1st date that an event occurs. Suppose that I see my first American Robin of the year on March 10 2011 and the folowing year on March 12 2012. The average 1st date would be, of course March 11th. However, when I enter the dates into Excel as 3/10 and 3/12, Excel automatically asssumes that they are for the current year. Using the averaging function, Excel gives me an average date of November 04 2011. Not what I want at all!

Here, I am trying to average 12 years worth of date, not just two, and there are 100's of species to record, so averaging this manually is quite a chore.

Can anyone see a solution? Thanks, Bob.

Comment on: E-Mail From Janet (by Allen Cody)

Allen Cody — 2011-05-18T10:41:35-07:00

I remember (circa 1985?) when I told my manager to give me access to the mainframe and I would create a spreadsheet to lay out a schedule for her. In those days Lotus 1-2-3 was only located on the company's mainframe computer and access was via one of the few terminals throughout the offices. I still remember her response -- "What is a spreadsheet?" I went on to create that spreadsheet and many more. Now I can't imagine getting my job done without a computer or the use of spreadsheets, and I work virtually. Using John's Excel VBA for Dummies book, I have created some pretty neat apps for my employer and my own use. Thank you.

Comment on: E-Mail From Janet (by Patrick M)

Patrick M — 2011-05-17T15:14:16-07:00

Back when I worked in a 50-person outfit, I once tried to convince one of our managers to approve buying everyone on the 15-or-so person consulting team a copy of Excel Formulas.

He said no; I should buy a copy for myself, and then mail it to whomever else was interested.

It would have been the least expensive, and yet probably one of the more effective, training initiatives we ever did. Sigh.

Comment on: PUP Sale Was Successful (by m-b)

m-b — 2011-05-15T09:08:07-07:00

Yes please.

Comment on: PUP Sale Was Successful (by Franck J. Dupuy)

Franck J. Dupuy — 2011-05-12T01:43:54-07:00

Hi John, Yes, please and if possible with a bit longer notice. Regards from Denmark.

Comment on: PUP Sale Was Successful (by Allen Cody)

Allen Cody — 2011-05-10T15:31:56-07:00

I'm in. I checked my email but did not see the offer. I will definitely buy. Please let me know, thanks.

Comment on: PUP Sale Was Successful (by S. Schulman)

S. Schulman — 2011-05-10T06:51:31-07:00

Yes, please with a few days notice!

Comment on: PUP Sale Was Successful (by Daniel Lamarche)

Daniel Lamarche — 2011-05-08T04:30:29-07:00

Hello John,

Bought a couple of your books (Excel 2010 VBA for example). Would love to hear early enough of your sales. I'm in Melbourne like a couple of others here. We might be asleep!!!

Let us know in advance. Good on you mate.

D. Lamarche

Comment on: Music Theory And Excel (by j)

2011-05-06T10:14:10-07:00

Are you able to develop a spreadsheet that generates chords (extended chords too)in all modes and scales?
I think it would be awesome for not only guitarists,but pianists and theory geeks alike (including myself).

And then, Take it one step further by implementing rules of harmony and showing chord progression.

Example: If I want to start on the ii chord and go to a vii* chord> choose a scale, mode, and then the data appears.
--just a thought

Comment on: PUP Sale Was Successful (by Charlie Harris)

Charlie Harris — 2011-05-05T00:15:00-07:00

Yes please (send secret url for those downunder.
Dont forget we are upside down)
From New Zealand

Comment on: PUP Sale Was Successful (by Charlie Harris)

Charlie Harris — 2011-05-05T00:12:45-07:00

I was asleep.

Please repeat and soon.

Charlie
New Zealand

Comment on: PUP Sale Was Successful (by BrianR)

BrianR — 2011-05-04T14:22:16-07:00

Please, please, yes. This idiot had set his phone alarm for 15 minutes before the sale started - and then hit "Off" instead of "Snooze".

Comment on: PUP Sale Was Successful (by Frank)

Frank — 2011-05-04T12:03:26-07:00

Yes please please please ... Thanks sooooo much!

Comment on: World Excel Champ (by spreadsheetpage.com)

spreadsheetpage.com — 2011-05-04T10:33:02-07:00

World_excel_champ.. OMG!

Comment on: PUP Sale Was Successful (by Simon Stininato)

Simon Stininato — 2011-05-03T21:19:54-07:00

Absolutely repeat. We're fast asleep in Australia & miss out.

Comment on: PUP Sale Was Successful (by Dale)

Dale — 2011-05-03T21:06:38-07:00

Please have another sale! 2am is not a good time to be trying to download stuff...

Comment on: PUP Sale Was Successful (by John Walkenbach)

John Walkenbach — 2011-05-03T17:48:59-07:00

The number of Australian customers is >6.

Quite a few have emailed me after the fact, and I've sent them a top-secret URL that allows sleeping Australians to get the cheap prices.

Comment on: PUP Sale Was Successful (by Toby Roberts)

Toby Roberts — 2011-05-03T17:32:13-07:00

It was 2am in Australia.So yes, please repeat.
Am concerned for the welfare of the 6 who actually got it here. You shoudl be asleep people.

Comment on: PUP Sale Was Successful (by Drew)

Drew — 2011-05-03T16:43:44-07:00

YES!!!! Just read about it on Chandoo and was too late on this one!

Comment on: PUP Sale Was Successful (by Oliver Montero)

Oliver Montero — 2011-05-03T16:07:44-07:00

Got one..cant wait to get home to try it :D

Comment on: PUP Sale Was Successful (by Kevin)

Kevin — 2011-05-03T12:59:38-07:00

Repeat! Repeat! Can't believe I missed it!!

Comment on: PUP Sale Was Successful (by tim wendel)

tim wendel — 2011-05-03T12:40:54-07:00

please do another offering. would buy both....

Comment on: PUP Sale Was Successful (by V Wankerl)

V Wankerl — 2011-05-03T12:31:18-07:00

yes, please do it again!

Comment on: PUP Sale Was Successful (by Ray Walton)

Ray Walton — 2011-05-03T11:49:53-07:00

Yes please. Up at 4am Wed, Australia time, but too late for the sale. Like to take up your 'after sale' offer for PUP v7 plus VBA code. Thanks Ray

Comment on: PUP Sale Was Successful (by Betty Raybold)

Betty Raybold — 2011-05-03T11:17:39-07:00

Yes, Please repeat the sale! I had the page open, but was called away from my desk!

Thanks, Betty

Comment on: PUP Sale Was Successful (by Steve)

Steve — 2011-05-03T11:12:26-07:00

Yes, please repeat

I have heard this offer only now but it's over

Comment on: PUP Sale Coming Up - Two Hours Only (by Steve)

Steve — 2011-05-03T09:31:32-07:00

...ditto

BTW Welcome back! I've missed your blogs - was getting worried

Steve

Comment on: PUP Sale Coming Up - Two Hours Only (by Martin)

Martin — 2011-05-03T08:10:55-07:00

Scratch my last comment - it is now working fine - the UK times must have been an hour out !

Comment on: PUP Sale Coming Up - Two Hours Only (by Martin)

Martin — 2011-05-03T08:00:08-07:00

Me neither Steve - 15:54 in the UK and get the message...

Special 2-Hour Sale Order Form
The sale has not begun yet.

Come back on Tuesday, May 3, between the hours of 11:00 am and 1:00 pm U.S.
Eastern Time (that's 3:00 pm - 5:00 pm GMT).

Comment on: PUP Sale Coming Up - Two Hours Only (by Steve)

Steve — 2011-05-03T07:38:12-07:00

Hi John...

...I'm ready and waiting - it's 3.30pm GMT on Tuesday but can not make the purchase...

Cheers John

Steve

Comment on: PUP Sale Coming Up - Two Hours Only (by Catherine)

Catherine — 2011-05-02T15:27:12-07:00

If you live in a time zone where you're sleeping during the sale, send me an email after the sale, I'll be glad to give you the sale price.

Thanks John, I too am in Australia! So Will send you an email .. Appreciate your offer to us downunder!
Cheers
Catherine

Comment on: PUP Sale Coming Up - Two Hours Only (by Manoj)

Manoj — 2011-05-02T13:07:25-07:00

This is a shout out to anyone who is reading this. This is one of the most outstanding utilities I have seen, and at this price it is a gift. I downloaded the trial utility, and it is fantastic. Do not miss this opportunity.

Mr. Walkenbach, you are truly amazing.

Comment on: PUP Sale Coming Up - Two Hours Only (by John Walkenbach)

John Walkenbach — 2011-05-02T06:29:12-07:00

Manoj, see End User License:

Comment on: PUP Sale Coming Up - Two Hours Only (by Manoj)

Manoj — 2011-05-02T06:20:02-07:00

Hi there

Is it possible to download this utility on multiple computers?

Comment on: PUP Sale Coming Up - Two Hours Only (by MK)

MK — 2011-05-02T06:14:24-07:00

Hello,

Just wondering if it is OK to take advantage of the free download for 1 day before taking a call?

MK

Comment on: PUP Sale Coming Up - Two Hours Only (by John Walkenbach)

John Walkenbach — 2011-05-01T19:04:36-07:00

If you live in a time zone where you're sleeping during the sale, send me an email after the sale, I'll be glad to give you the sale price.

Comment on: PUP Sale Coming Up - Two Hours Only (by Rick Southard)

Rick Southard — 2011-05-01T18:40:39-07:00

I am in South Korea an would appreciate an aternative time to place my order as well. 11AM eastern time is 12AM my time and I have to get up at 4AM...really a bad time for me unless it is on your Friaday or Saturday when I will not have to go to work the next day.

Comment on: Displaying An Annual Calendar (by spreadsheetpage.com)

spreadsheetpage.com — 2011-04-29T13:50:06-07:00

Displaying_an_annual_calendar.. Very nice

Comment on: PUP Sale Coming Up - Two Hours Only (by John Walkenbach)

John Walkenbach — 2011-04-29T12:04:11-07:00

Thanks. I fixed the time.

Comment on: PUP Sale Coming Up - Two Hours Only (by Ninad Pradhan)

Ninad Pradhan — 2011-04-29T01:02:50-07:00

Hi John,

You order link page states 4:00 - 6:00 GMT and this page states 3:00 - 5:00 GMT. Could you please update this to the right time. I've set a task reminder for me at 8:00 (Dubai time) which is 4:00 GMT to purchase this. It's a real deal and don't want to lose out on it.

Ninad.

Comment on: PUP Sale Coming Up - Two Hours Only (by Michael Silberthau)

Michael Silberthau — 2011-04-28T20:58:03-07:00

I am also from Australia. I would also appreciate an alternative way to place my order.

Cheers,
Michael

Comment on: PUP Sale Coming Up - Two Hours Only (by Joe)

Joe — 2011-04-28T17:45:25-07:00

Sounds like a real bargain, unless you live somewhere like Australia and will need to get up at 1:00AM to take advantage of the offer. Is there any other way I can place my order?
Thanks

Comment on: Missing File Posted (by Monkey)

Monkey — 2011-04-19T07:37:02-07:00

Walking in the presence of giants here. Cool tihkning all around!

Comment on: How Fast Is Your System? (by Jim Cone)

Jim Cone — 2011-04-15T08:51:44-07:00

Information...

"Rnd" is a VBA function it is not a variable.
It returns a random value less than 1 but greater than or equal to zero.

Declaring it as a Single just makes it a variable with a value of zero. That is why the code runs faster.

The modification to make is...
Change: If Rnd <= 0.5
To: If Rnd <= 0.5!
(the ! is the type declaration character for Single)

Comment on: Hiding & Unhiding With Shortcut Keys (by mariel_ar)

mariel_ar — 2011-04-15T07:57:58-07:00

XP SP3 - Excel 2007 v.12.0.6545.5000

All work fine.

Rgrds,

Comment on: How Fast Is Your System? (by Bill McNair)

Bill McNair — 2011-04-14T07:11:40-07:00

Original version: 6.783203 secs
Helmuth's version: 2.054688 secs (in VBA window)
Helmuth's version: 2.050871 secs (in spreadsheet)

Windows Vista 32-bit;
Intel Core2 Duo E8400 @3.00GHz
Excel 2007 32-bit

Comment on: Hiding & Unhiding With Shortcut Keys (by Guilherme Poleto)

Guilherme Poleto — 2011-04-10T18:40:51-07:00

It works for me! Windows 7 + Office 2010

Comment on: How Fast Is Your System? (by Allen Cody)

Allen Cody — 2011-04-09T11:11:56-07:00

4/9/2011
Wow! Just ran again with Helmuth's macro (#1389) and came in at 1.929688
Other version at 4.476563

Windows 7 Home Premium 64 bit
Office 10
i7 CPU 870 @ 2.93 GHz
8.0 Gig RAM

Comment on: How Fast Is Your System? (by Allen Cody)

Allen Cody — 2011-04-09T10:58:35-07:00

4/9/2011
Just finished your Excel VBA Programming for Dummies -- excellent starting point. Thanks. Have already written a few [simple] macros.

My very new i7 CPU 870 at 2.93GHz w/8.0G RAM came in at 4.476563

Comment on: How Fast Is Your System? (by Niketya)

Niketya — 2011-03-23T14:04:58-07:00

Follow on to post #79.

New system. HyperThreading, SpeedStep and TurboBoost are all enabled. Using ThrottleStop I set the multipler to Turbo.

OS: Win 7 Pro 64 bit
Office: 2010 32 bit
CPU: Core i7 860 @ 2.80 - 3.30 Ghz
RAM: 8GB

Code unchanged: 4.765625 seconds
Helmuth's changes: 2.03125 seconds

I don't get the above numbers on my dell precision workstation.

Comment on: Hiding & Unhiding With Shortcut Keys (by Kris)

Kris — 2011-03-23T01:44:40-07:00

Hi Rick,

The link
http://support.microsoft.com/kb/967893 worked for me! Thanks a ton.

Kris

Comment on: PUP v7.1 Is Available (by Robin Burnett)

Robin Burnett — 2011-03-07T01:26:53-07:00

Thanks a lot John, much appreciated!

Comment on: PUP v7.1 Is Available (by John Walkenbach)

John Walkenbach — 2011-03-03T08:32:24-07:00

Robin, the PUP user manual is here:

http://spreadsheetpage.com/index.php/pupv7/documentation

But there's nothing wrong with random exploration of PUP. I would really recommend clicking various tools and see what you get. Some will be useful, and some won't.

Comment on: PUP v7.1 Is Available (by Robin Burnett)

Robin Burnett — 2011-03-03T08:19:14-07:00

I have just added PUP in to my Excel. I aim to use it to help me 'audit' financial models. Where can I find training, guidance or a user manual for PUP? I am keen to learn all of its functionality, and simply 'having a go' doesn't seem to me to be the best way of doing this!

Comment on: Excel 2010 Book List Updated (by Jon Mourar)

Jon Mourar — 2011-01-21T07:13:31-07:00

John,

Thanks for your reply. Yes, the sentence is correct. I was a little hasty in my criticism, although I did read it several times before I made my comment! Not sure why I didn't see the light before I posted. I don't think it is unclear, I just misinterpreted. Overall, I think you explain things very well. Thanks again.

Comment on: Excel 2010 Book List Updated (by John Walkenbach)

John Walkenbach — 2011-01-20T12:12:36-07:00

Jon, it's actually correct. But it certainly could have been written more clearly.

Comment on: Excel 2010 Book List Updated (by Jon Mourar)

Jon Mourar — 2011-01-20T12:11:34-07:00

Sorry, John, I made an error. Upon re-reading the sentence, I realize you are talking about all the instructions under the case executing, not all the true cases. Sorry for the misinterpretation! Probably would be good to explain that only the first true case is executed though.

Comment on: Excel 2010 Book List Updated (by Jon Mourar)

Jon Mourar — 2011-01-20T12:04:45-07:00

John,
I believe I found an error in your Excel 2010 Formulas. I hope this is the appropriate place to post it. On page 651, you are explaining the Select Case construct in VBA, and say in the last sentence on that page that "Any number of instructions can be written below each Case statement; they all execute if that case evaluates to TRUE." I was pretty sure that was wrong, so I tested it (and looked it up in VBA help). It only executes the first true statement. Other than that, I love your book!
Jon Mourar

Comment on: Problems With Euro Currency Tools Add-In (by PerHogan)

PerHogan — 2011-01-18T03:31:14-07:00

i lost 2 days to understand the issue...
the weird thing is that it worked fine till the day before...

Comment on: PUP v7.1 Revisited (by Jim Cone)

Jim Cone — 2011-01-10T21:12:24-07:00

John,
Can you provide more information about the "replacement" of the older vba versions with v7.0?
Were all three of your Excel versions on the same drive?
Do you know if the version replacement occurs if Office 2010 is installed on a separate drive?
How did you determine in the older versions that the replacement had taken place?
Any idea if Excel 97 would be affected?

Comment on: PUP v7.1 Revisited (by John Walkenbach)

John Walkenbach — 2011-01-10T14:00:38-07:00

It's available now, Martin.

Comment on: PUP v7.1 Revisited (by Martin Hanson)

Martin Hanson — 2011-01-10T10:06:44-07:00

Is there an update to when V 7.1 will be released? I have been struggling with no having this utlity on my new laptop; I'm guessing becuase I am running Windows 7 64-bit, that is my problem--I have Office 2007. The only function in V 7 that works is the programs "About" click.

Comment on: PUP v7.1 Revisited (by Wendy!)

Wendy! — 2011-01-09T19:35:44-07:00

Oh yes, The actual google result that led me to the Spreadsheet page:

try:
http://www.j-walk.com/ss/excel/files/xdate.htm
Whosoever shall say unto this mountain, Be thou removed, and be cast into the sea; ... , it shall come to pass; Mark 11:23

Now THAT was confusing. It would have been more appropriate to finish with Job 11:17 And thine age shall be clearer than the noonday: thou shalt shine forth, thou shalt be as the morning.

Comment on: PUP v7.1 Revisited (by Wendy!)

Wendy! — 2011-01-09T18:26:14-07:00

I was trying to figure out how old my grandfather was, and I could not subtract his birthdate from his death date...hmmm.... google it, I thought. I didn't want to use a pencil!
Imagine my surprise when the search led me to The Spreadsheet Page XDate: Extended Date Functions Add-In

"Many users are surprised to discover that Excel cannot work with dates prior to the year 1900..."

Yes, I was certainly surprised! And I am certain my grandfather would have been surprised also, had he not died in 1972 at age 94!

I was particularly proud of myself that I even had the solution all along with my handy Pup7!

Comment on: Excel 25th Anniversary Article (by Doug jenkins)

Doug jenkins — 2010-12-31T00:34:17-07:00

"While largely unnoticed, 2010 marked the 25th anniversary of perhaps the most revolutionary software program ever, Microsoft Excel"

Excel revolutionary? Hardly.

A successful evolution of other peoples' revolutions, certainly.

Comment on: PUP v7.1 Revisited (by jmnorthcutt)

jmnorthcutt — 2010-12-26T09:32:12-07:00

Unfortunately I bought the 64 bit version of 2010 because that is what we are going to go with at work next year. So,I would like to know how to get PUP7 working.

I am not a programmer so you may need to dumb down some suggestions for some of us.

Thanks

Comment on: How Fast Is Your System? (by Jim Cone)

Jim Cone — 2010-12-25T15:04:06-07:00

Follow on to post #40 of 13 months ago where time was 21.5 seconds.

With new computer from under the Christmas tree:
I3 Processor x86 Family 6 Model 37 Stepping 5 Genuine Intel ~3200 Mhz
4 GB ram, Windows XP, Excel 2003

I get the following results...
4.70 seconds
4.64 seconds (declaration as Single)

Comment on: How Fast Is Your System? (by Richard)

Richard — 2010-12-25T10:29:26-07:00

5.24 seconds
Intel Core i7 920 2.67GHz, 6GB ram, Windows 7, 64-bit
with a few things running

Comment on: Hiding & Unhiding With Shortcut Keys (by Rahul)

Rahul — 2010-12-21T04:43:27-07:00

For me also last one does not work well. But the above all works well.I am using windows 7 and Excel 2003.

http://godwinsblog.cdtech.in/2010/12/microsoft-office-excel-add-in-plug-in.html

Comment on: How Fast Is Your System? (by RookiePL)

RookiePL — 2010-12-18T09:02:29-07:00

8.16 sec on Athlon 240 2.8Ghz dual core
2GB ddr2 800
640GB WD drive

Comment on: How Fast Is Your System? (by Mike)

Mike — 2010-12-02T11:26:36-07:00

Sad, sad little machine...

14.42188 seconds (original formula)

Intel (R) Pentium (R) 4 CPU 3.60Ghz
3.59 Ghz, 2.00 GB of RAM
MS Windows XP Professional
Version 2002 Service Pack 3

Comment on: How Fast Is Your System? (by Helmuth)

Helmuth — 2010-11-28T01:27:16-07:00

I took Rick's code,
did a little bit tidy up(unimportant) but
defined rnd !!!!

rnd undefined defaults to VARIANT !!!!!!!

Time it took undefined: about 8 secs
Time it took defined: about 2,35 secs !!!!

Not so bad?

Sub TimeTest()

'100 million random numbers, tests, and math operations

Dim x As Long
Dim i As Long

Dim StartTime As Single
Const Half As Single = 0.5
Dim rnd As Single ' originally rnd is undefined and defaults to a Variant !

x = 0
StartTime = Timer

Debug.Print StartTime, Half

For i = 1 To 100000000

If rnd <= Half Then
x = x + 1
Else
x = x - 1
End If

Next i

Debug.Print Timer - StartTime & " seconds"

End Sub

Comment on: How Fast Is Your System? (by Eugene)

Eugene — 2010-11-26T23:18:13-07:00

9.70

Intel(R)Core 2Duo T7250 @ 2.00GHz
Window XP Office 2010
by the way great site.