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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.