Recent content by MrBramme

thank you for checking this. I did make use of manual breaks. I'll start scripting my back-up plan i guess :)

Thanks, that was my back-up plan really, was hoping it would be a simple matter of flicking an option to true or false before saving :)

Hi, I'm currently preparing some code that generates 200 reports automatically. There's just one problem i can't solve. I've got my "master" template all set up with page breaks, and at the end of the line it's saved to PDF (Yuck, PDF. don't shoot me, it's how they want it :) ). The problem...

Hi, I've decided to switch out my pencil&paper tracking of my power consumption at home to a digital version. This is a personal project so no pressure, but still, I wouldn’t be myself if I didn’t try to push my Excel software to the max :) I have some idea’s with time filters, comparisons...

that pretty much looks like EXACTLY what I need :) I'll need to experiment in my batcave tonight ;-) Thanks!

Hi, I'm trying to add a portion of a worksheet to a userform with the hopes of manipulating it (pleast note, this will be used in powerpoint etc as well, so I cannot rely on excel solely, hence the reason why I need a worksheetlike table on a userform). I have googled plenty and saw that...

thanks for the heads up Hui, I'll keep an eye out for the little buggers :) Might be a "semi" fix to keep the bar in the same color as the error bar so there's always something ... and the color is off course pink ;-)

Many thanks for the replies, especially for the lovely pink charts, i guess i should have mentionned this was a google picture search result and i didn't need them pink ;-) but last night it hit me like a brick what I did wrong with the error bars. they offer the best result as they'll fit on...

Hi, Can anyone help me to figure out how to make bar charts (so bar's going up vertically) with rounded tips? example here : http://blog.visual.ly/wp-content/uploads/2013/04/rounded-bars.png?547b7b Am using office 2010. I tried different methods (error bars, secondary chart with dots, ...)...

Sorry for the late reply. I tried the 3 approaches, but I think I'm doing something wrong, It's not working for me :( please note, I'm using ; in my formula's rather than , .... :) You guys mind on taking a look again? :) here's an example file, since I'm sure that'll be much more efficient...

Hi, I'm looking for a way to do a vlookup for a partial of the text. example lookupdata: COL A |ColB Store 1 |Belgium Store 2 |UK Store 3 |Netherlands so then i'd like to place a vlookup in the data below to find the store location (col B) COL A |ColB XXXXX Store 1...

How about making a helper column for this? I can experiment on it at the moment but basicly: you get 2 actual bars (both copies of each other) with the copy linked through formula's. cap this one off at the target value (so if there actual value goes above target value, in the copy the actual...

Just curious, and hoping to draw more inspiration to add to my existing add-in: What are your most used / handy / ... VBA functions, userforms, macro's, ... ? example: My most handy piece of code is my personal Add-in. It has many features I use daily, one of which is a selection rotator...

Ohnoes, I missed it by 12 ..... :) Congrads!

Hi, I was using worksheetfunctions, but someone told me that array works the fastest of all, hence my swap to arrays :) The code itself spans over 3 modules with different subs ... i've broken it down in parts you see :) - module 1: setup --> reads all data, checks for errors, etc etc...