bold font

Hello, I have a VBA sub sending an email with outlook. I am looking to have some parts in Bold characters. I thought of using .HTLMBody in the code based on some posts I saw. Where’s the catch? Well the parts I’m looking to put in bold characters are variables from a worksheet... I did...

I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet. Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column. I...

Col M contains a keyed value for "trip segments". If the trip was made w/o stopping Col M = 1; one stop = 2; two stops = 3; etc M2 = " Stopped along route on "&(SUM(M17:M382)-COUNT(M17:M382))/COUNT(M17:M382)*100&"% of trips" That is not 100% accurate, but it's close enough. More than 1...

I have a workbook with a lot of subroutines that I've authored. I am having an issue with one of my subs taking way too long. For this investigation I used the Task Manager to track down the problem. When I start the sub(routine), Excel is using 100MB of memory, when it's finished Excel...

I am compiling a list of BOMs. It will first list the assembly name, and then list all of it's components in the rows underneath. The assemblies name and fields pulled with it must be bold. The list of components underneath it must be group together, so i can collapse all the groups and just...

Hi All, I was wondering if anyone knew of a way to write a macro that would add a top border to some cells in a selected range. All of my number data is columns I:O with subtotals every so often (example of columns F:O below): <TABLE style="WIDTH: 451pt; BORDER-COLLAPSE: collapse" border=0...

Is there a way to filter based on whether cells contain bold font? I'm using Excel 2010. Thx in advance.