Applications

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

HALF OFF Charley Kyd's Dashboard products

I am proud to be affiliated with Charley Kyd’s Excel User Dashboard products (see the little graphic on the left hand side). I can heartily recommend his excellent products.

Charley is having a HALF OFF sale as well as some other amazing benefits. Here are the details:

ebook-250 Until midnight this Friday, you can get my best dashboard products for HALF OFF.

Here’s where you can grab your copies for half off.

I’m holding this special sale as a way to say THANK YOU to my customers and people who read my Excel For Business newsletter.

Here’s where you can grab your copy and save 50%.

Try My Dashboards for 50% And Get Six Free Bonuses.

If the 50% discount isn’t enough to have you heading to my half-off catalog page, these SIX free gifts will surely do the trick.

•  Bonus 1: One-Hour Live Webinar about IncSight QnE
This live webinar will show you how to set up and use IncSight QnE, and how to adapt its templates to meet your specific needs. I'll show you how to add or subtract periods, change periods to any that you want, add calculations, change chart sizes, change color schemes, and a lot more.

jethro's picture

The week in review

I don’t know why I seem to write massive link posts lately – maybe because i have been very busy with my three major priorities, family, work and photography. However this is a priority as well, so I need to allocate some time to write soon. In the mean time I am going to clear my browser of the tabs that are open there.

2009-11-06 BTUB 123 Here goes – and have a great weekend. Oh – and this photo was my favourite of the week. I took it in low light, no flash using the 70-200 2.8 IS L Lens.

Exposure 1/128, Aperture f2.8, focal length 170mm, ISO 2000

Photography Links

jethro's picture

Office DevCon has been a big disappointment so far

So I was all excited. Office DevCon 2009 was in Brisbane this year. We develop in Excel and VBA. I was looking forward to networking with others who do the same, and learning some new techniques and tricks.  odc09_logo The session track précis hinted at new reporting techniques, building reports for excel-centric clients, new VBA forms and more. I skipped the first day because there was only 1 session I wanted to go to. I was all excited about the second day because I thought (wrongly) my desires would be met. But no. I should have read the presenter profiles page first!.

These guys were all Access gurus. And they seemed to know what they were doing, but when it came to Excel they ignored the massive functionality of Excel, and treated it primarily as a report display system.

I think I am going to offer to present next year.

jethro's picture

When Excel 2003 doesn't display data and Excel 2010 information

I came across an interesting issue yesterday. I found a limit that I was previously unaware of in Excel 2003.

ExcelI had written some code that was taking data from a large data set into an array, filtering for some specific information and writing the results to another array. Then I was attempting to paste that array data into a range in the spreadsheet as a report. All was working well until I selected one specific set of inputs and ran the report. Suddenly it stopped pasting halfway though the paste. That is it would paste some of the data and not the rest and the code would break on the paste function. After some analysis I determined that the particular cell it kept breaking on had 1400 characters in it. Some research on Google helped. I discovered two things.