Hi all,

Time for some ‘culture’ for me this weekend.

Over at my place (Weert, The Netherlands) this weekend is all about the huge fair (AKA Carnival so I recon) we have in town.

We have about 140 attractions ranging from shooting galleries to serious roller coasters, and from fresh fruit bars to gambling alleys.

The funny thing is, Google happens to have taken the pictures for Google Earth, when last year’s fair was on. Here are a couple of them:

Kids roller coaster and shooting galleries.

Another coaster and a merry-go-round.

And a ferris wheel!

And if you’re Dutch, here is the Fairs’ site and here are some pictures of last year

So what are your plans for this weekend?

OK, time for some non Excel 2007 stuff…

Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.

What the poster wanted is to go from:

To:

Read on here.

Regards,

Jan Karel Pieterse

JKP Application Development Services

Founding member of:
Professional Office Developers Association

Hi everyone,

Since no new issues were reported for quite some time, I decided it is time to release Name Manager version 4.0.

Look here and here for previous posts and discussions on this version.

Enjoy!

Regards,

Jan Karel Pieterse
JKP Application Development Services

Hi all,

In this post I announced some updates to version 4 of the Name Manager.

Since I haven’t had any bug reports for about four weeks, I have decided it is about time to release this version.

Before I do so, I give you guys (and girls of course!) a last chance to report any issues to me.

So have a go at it, break it! If I get no new issues back, I’ll post the release in about one week.

Regards,

Jan Karel Pieterse
www.jkp-ads.com

This article describes a bug recently discovered by Ron de Bruin and which has also
been reported here.

The Application.InputBox function is very useful to get a range from
the user. Unfortunately, this function exposes a bug in Excel (all current
versions!). If the sheet on which a (range of) cell(s) is selected contains
conditional formatting using the : “Formula Is” option, the function may fail,
returning an empty range.

The only reliable workaround is to build a userform to request the range from
the user, which I have included as a download here.

Hi all,

An update to version 4 of the Name manager is out.

I have worked hard to weed out the bugs reported to me so far. Things are definitely looking better and better.

Also I have added a feature so you can see where a name is in use. Press the “Is name used” button to get this dialog:

Have fun trying the new features!

Download here

Regards,

Jan Karel Pieterse
JKP Application Development Services

As you may recall, I’ve written about registering User Defined Functions before.

The problem with the trick I used in that post, was (and this isn’t trivial): it crashed Excel.

KeepITCool came up with yet another trick to make this work, which I have described in
this article.

Enjoy!

Regards,

Jan Karel Pieterse
JKP Application Development Services