Created an Excel macro that 'freezes' information on all worksheets of a workbook

Our 25-worksheet monthly report workbook has gobs of calculations throughout. Information is even pulled from another workbook to complete the calculations. Problem has occurred when sending the final monthly report workbook to the customer - I would have to manually open each worksheet, highlight it, copy it, and use Edit / Paste / Special to paste only the Values. Too time-consuming, so I worked up the following macro:
_______________________________________

Sub EditPasteValues()

' I'll want to return to the current worksheet
' when this is done, so I'll save its info for
' future reference:

Dim CurrentSheet As Excel.Worksheet
Set CurrentSheet = ActiveSheet

Dim Sheet As Excel.Worksheet
Dim CurrentWindow As Window

' Here, I'll cycle through each of the worksheets,
' performing the select all cells, copy all cells,
' Edit / Paste Special / Values so that any formulas
' are wiped out and only the final values remain

For Each Sheet In Excel.Worksheets
If TypeName(Sheet) = "Worksheet" Then
Sheet.Activate
Set CurrentWindow = ActiveWindow
Application.Goto Reference:="R1C1"
Cells.Select
Selection.Copy
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("A1").Select
End If
Next Sheet

' Here I'm returning to the original worksheet
' that I saved above

CurrentSheet.Activate

End Sub
_______________________________________

Have you seen google's homepage today? -

There are entries (some from Kindergartners!!) from the recent contest for the best doodle. The winner is a sixth grader from Texas. I'm trying to think back to what I was doing in the sixth grade: homework, playing outside, running around with my bestest friend in the whole world.

Back when I was 13 or so, there was no computer or Internet or cable TV or DVDs, or VHS even. We went to a theater to see movies, and they cost probably $2 to get in. And TV was just three mostly clear channels (NBC, CBS, ABC), and one channel that was pretty bad but still watchable (WDCA in Wash. DC) and we liked it. We sometimes had to adjust the rabbit ears, though (oh the horror of it all!!) and without a remote control, we had to get up off the couch to change channels or adjust the volume or turn the TV on and off (yikes!). Oh, and for the smartasses, yes we did have color (smirk). This was particularly troublesome when we had to answer the phone which was totally wired to the wall; we had to answer, tell the caller to hold on, walk over to the TV and turn it down, come back to the phone, and talk (or in our parent's case, they'd yell to me or my brother to turn down the TV without having to leave the phone, sorta like their very own living remote controls).

Ah, the memories. . . . In 10 years time, when these kindergartners are teens, I wonder how the world will be different for them? I'm looking forward to finding out, that's for sure!!

The NYT says today that by paying off my credit card bills every month I'm considered a deadbeat -

The NYT fronts a look at how banks will now be looking at ways they can make more money from some of their best customers. Well, "best customers" might be how you commonly think of the people who pay their bills in full and on time every month, but they're actually called "deadbeats" in the industry because they don't generate much revenue for the companies. These customers have not only failed to give much revenue to the poor credit card companies, but they dared to demand things like cash-back rewards and frequent-flier miles. That may soon be a thing of the past. Now that Congress wants to impose limits on how much the companies can charge riskier borrowers, they're looking at how they can increase revenue from those with good credit. Banks are likely to bring back annual fees, cut back reward programs, and charge interest immediately upon a purchase. Or at least that's what banks want people to believe as they furiously lobby lawmakers, who are discussing a wide variety of rules that could soon be imposed on card companies. "Those that manage their credit well will in some degree subsidize those that have credit problems," said the head of the American Bankers Association.

(Source: Slate Magazine)

Reading a Book Called "Red Mars" by Kim Stanley Robinson -

Interesting reading re Gov't power as @PeterSantilli tweet implies. This one is 1,770 pages on my Sony eReader. There are two followup books, "Green Mars" and "Blue Mars" that I'll probably get and read. This first one has taken up about 2 weeks of my reading time so far (I'm on page 1,246). Don't know how long the other two are.....

The Bullpen at DC's National's Park Is Now Open

http://www.thebullpendc.com/www/ - Gotta check it out!

Society for Competitive Intelligence in Wash DC

has an interesting blog: http://scipdc.wordpress.com/

They have an upcoming event re using media analysis for scenario projections.

Twitter has lost most of my feeds

so I'm gonna blog my tweets (sounds groovy, don't it?!!) from now on!

This first one is a test to see if Twitterfeed does what I think it will.

I was using Twitter as a sort of history timeline diary, but I should've stuck with Blogger. Sorry Google, that I strayed!

PDF Annotator

Just downloaded and installed the newest PDF Annotator (version 2) from Grahl Software. It's got a LOT of new stuff. Highly recommended!! (I don't work for Grahl, I'm just a very satisfied customer.)

Greatest . . . Purchase . . . Ever!

Well, it's maybe not the greatest purchase ever, but it ranks right up there!

Picture it: We usually put off until Sunday evening (don't we all??) to wash, and there's sometimes a mad scramble to get there first. We bought one of these Whirlpool portable washers and it's really working great for us.

It's quick, too -- even the longest cycle takes less than 45 minutes or so. Plus, we can pause it mid-cycle and let stuff soak for as long as we want. We keep it in the little closet under the stairs that's in the laundry room. When needed, we roll it out and hook it up. When done, we roll it back out of the way.

Highly recommended!

Where ARE we headed??!!

So here's an entirely scary concept: Kevin Phillips, in his article The Old Titans All Collapsed. Is the U.S. Next? presents startling evidence that we're gonna have a MAJOR headache a few years from now. Interesting reading.

Landscaping Hardscape

Been thinking about redoing the landscaping at home. The little gardens to the left and right of the front door have gotten NASTY over the years. Weeds everywhere, plants dead or dying, geez. I've taken care of the trees in the front and back yards, replacing the mulch. Looks GOOD! So now it's on to the gardens. I just ADORE this look.....

Trend for Old Folks and Insurance

Mom's trying to figure out which insurance plan to go with for her Medicare/Medicaid/retirement.

She's gotten information from several companies (Humana, BlueCross/BlueShield which she uses now, AARP, and so on). Turns out that all the plans are 95% the same!! She says the presentations and documentation that she's been reading is mostly repetitive, with just a few tweaks here and there between the different companies, and slightly different costs.

I think she's going to stay with the BC/BS plan 'cause none of the others are way different.....

Showing Google Earth in a Browser

Well, they finally did it! You can now use Google Earth in a browser plug-in instead of loading the software application. Go to code.google.com/apis/earth to download. Sweet!!

The Japan Shop

Learning Japanese like I am? Check out The Japan Shop. Very nice folks (Clay and Yumi are their names), very good prices.

They've started doing these little $5 "Instant Downloads" which are quite interesting. It may be a Japanese story (in Japanese, of course!) with flash cards, a PDF of the readings, an audio recording at full speed and a recording where the speaker speaks the words slowly for studying, etc. Or it could be a study guide for Japanese sayings with flash cards, PDF, audio recordings, and so on. I've picked up the ones published so far. They're great, and have helped me learn a lot of Japanese, plus at only $5 per download, it's an economical way to study.

They also sell regular books and dictionaries, electronic dictionary devices, study guides, the JLPT study series, and on and on. They EVEN have free stuff for download!

Check 'em out! (By the way, I'm not affiliated with them in any way, except as a very satisfied customer.)

What's on my playlist now?

Ida Corr's new album, Streetdiva. Be sure to check out the "Let Me Think About It" Club Mix with Fedde Le Grand

Brother's Wedding Anniversary

Today is Rob and Lindy's 24th anniversary. According to about.com, the 24th anniversary is for musical instruments. Hmmmm.....

Spacecraft spies probe parachuting to Martian surface

Very Cool! You can actually see the Phoenix parachuting to the Mars surface!



http://space.newscientist.com/article/dn13981-spacecraft-spies-probe-parachuting-to-martian-surface.html?feedId=online-news_rss20

The Republicans Have Ruined Us

The war, now absurd gas prices? What next -- or should I tempt fate by asking??

Yee ha!

From Joke of the Day

M&M's

An old man and a young man work together in an office. The old man always has a jar of peanuts on his desk, and the young man really loves peanuts.

One day, while the old man is away from his desk, the young man yields to temptation and scarfs down over half of the contents of the jar. When the old man returns, the young man feels guilty and confesses to his crime.

"Don't worry, son. I never eat the peanuts anyway," the old man replies. "Since I lost my teeth, all I can do is gum chocolate off the M&M's."

Need a reason for an HDTV?

Well, you have a few hours to go get one before Discovery HD channel starts its 5-week run of the series 'Planet Earth' tonight at 8pm.

The whole series is done in HD, and as USA Today says, 'it could be that only an IMAX will be enough' to show how great the picture is.

My TiVo is ready and waiting.....

Source: Engadget HD