Search results

Instead of "olMail.body", use "olMail.HTMLBody". This will allow you to add HTML markup to the body text of your email message. What you want to make bold, surround with <b> and </b> tags i.e. "<b>Cost Centre:</b>". You can also use other HTML tags as necessary.

Yeah, yeah :)

Was crtl shift enter not needed? Like I said in my introduction, sometimes I type before thinking :P

I think this should do it: =SUM(OFFSET(B501,0,0,A1)) Make sure you press CTRL+SHIFT+ENTER after typing it in

I'm actually embarrassed to even post this.... Q: How many Excel developers does it take to screw in a light bulb? A: =SUMIF(AvailableToHelpScrewInLightBulb,1)

This might be helpful for you, too: http://www.buzzle.com/articles/calculate-percent-difference.html

Well, that all depends on which of the cells above are the original and new amounts. If we let A1 -> Original Amount and B1-> New Amount then the percentage increase and decrease formulas are as follows: Percent Increase: (B1-A1)/A1 and Percent Decrease: (A1-B1)/A1 Both formulas...

A PivotTable walks into the bar and orders a beer. He says to the bartender, "put me on the same tab, will ya?"

An outlier walks into a bar and says to the bartender, "sometimes I feel as if I've lost the plot." An residual error walks into a bar and the bartender says, "hey, get inline!" ... and that's why comedy career never took off

@SirJB7 I would love a customizable grid size, the future is definitely headed in that direction. Right now, the grid size I use is based on my own personal preference. To set the square sizes, I use the same code from my blog post, The MOST Squares Method, excerpted below (Get the the pun??)...

Hi everyone! I'm Jordan. I'm somewhat new to the forums, but not necessarily new to Chandoo. You may have seen my name before in a few articles dealing with "Interactive Hyperlinks." I really enjoy learning from people about Excel and helping them with their efforts in kind. The thriving...

This is the code that apparently works listed on response #5 of the link I posted. With Application .SendKeys "{ENTER}" .Run "ATPVBAEN.XLAM!Mcorrel", rng, ActiveSheet.Range("$O$8"), "C" _ , False End With I'm not an expert on this add-in, so I can't really speak to what's going on...

@SirJB7 - I like your ideas. Ever since reading Denial Ferry's articles about Sumproduct and "I heart IF," I've really avoided use lookup functions and ifs. Here, I don't think using Match and an iIf really makes a negative difference on speed. If anything, it makes the work more readable. I...

Yes, that makes sense. MCorrel is a 3rd party product, so what pops up is a considered a message and not an alert - at least not to the Excel application. I did find this forum post in which someone found success using the SendKeys command to send the "Enter" button to the prompt before it...

Is there a reason why you prefer to not use PivotTables? I would think the easiest way to split up this data is to apply an AutoFilter to your dataset and then sort by account number. This will group every account of the same number together. Then copy/paste each grouping into your next tab...

What is being displayed? Some "alerts" are not flipped off by using that statement.

Montrey, I'm not sure that solves the problem. Danrosey was asking how to ensure the graph only shows the months to date. Using your method, the problem still exists as the chart will show empty data for months beyond the current date. Luke's technique will automatically adjust the size of the...

Thanks Kaushik03! As Narayank991 suggests, you will want to thoroughly review that blog post. If all of this is new to you, I suggest you start at the very beginning with Chandoo's tutorial: http://chandoo.org/wp/2011/07/25/video-on-interactive-dashboard-using-hyperlinks/

Great! :)

Oh yeah, I forgot about that. If you initially selected a scatter plot with lines connected when you first created this chart, any new series will assume this style by default. So what you need to do is select the new series, right-click, then go to Format Data Series. From here, select a...

Ha-yes! They were picked completely at random. I'm glad to help with your research, if only by accident. Make sure though you understand what's going on and why it works. And hi to you too, SirJb7! I've been lurking for far too long. Figured I'd try to help where I could ;)

Wlerner, Is this what you are looking for? https://docs.google.com/open?id=0B1OBNnu3ZbL0enV5aXpDTzVobTg If so, let me know where you have questions. Otherwise, we'll try again. :)

I'm still just a bit confused. I think the file would help, if you're able to present it here. Are you trying to create the curve of a normal distribution upon which to map your set of 27 items?

Justin, if I understand correctly, you're looking for a mechanism to popup information about a state when your mouse moves into its region? Using "rollovers" or "interactive hyperlinks" (I call them the former, Chandoo the latter), you can do this as is shown in the file below...

Hey kaushik03, I wrote the article above referenced by NARAYANK991. I used the technique to develop this file for you: https://docs.google.com/open?id=0B1OBNnu3ZbL0aXhTMEtzS3QzQTQ Is this the type of capability you were looking for?