bold

Good afternoon, I have a workbook that has 5 or more sheets. The sheet I require this macro in is called "TRIAL" The sheet contains a data dump from another software program and I would like to create a macro and make the following happen: Look at column J AND column L - if there is no data...

I am looking for formula for a macro which will automatically bold specific words. The data is in column A. I have various words I would like to be bold. Any help is greatly appreciated.

Hi! I had a problem and Fluff and Mumps solved it both professionally. I am practising now, so I try to modify their codes, but there is something wrong. I want to keep the part of their codes, which splits the cell's content after every space, but at the command part, what i highlighted...

Hi, I have been toying with an email macro that bulk emails clients with taylor made near identical emails in the click of a button. I am almost done however I have encountered a minor issue whilst trying to add a bit of flair to the signature. Does anybody know how I would correct this code...

Hi! I know that there are a lot of mistakes, but I would like to solve this problem by using my current knowledge. And it seems to me that there is just one row in my code that is missing... I can't finish it, making bold what i want. Can you help me? Have a nice day https://imgur.com/a/AKIrdM8...

Hello! I need to bold the entire 'Grand Total' column. Now the number of columns varies so I am trying to find a way to lookup if the column says Grand Total and if so, bold that whole column. Below is what I have so far. There can be a maximum total of 61 columns (including the Grand Total)...

Hello I am trying to write a script that will look through column b (To the last row) for the specific text "Text to Format" and make this text bold. I don't want to make the entire cell bold, only the words "Text to Format". Thank you!

Hi i have the code below where i want the F6.value (located underneath the .HTMLBody and highlighted in BOLD)) to be directly underneath the 2nd of the Replans (highlighted in BOLD), i have tried the CHR and the VBR but they are not working, can you help please? Private Sub...

Hello there, I'm wondering if Excel's drop down menu allows you to format the color of the options provided in the drop down box. I am essentially trying to make three symbols appear in the drop down: a bold red up arrow, a bold green down arrow, and a bold orange em dash. I have these...

Afternoon Trying hopelessly to format the first 3 cells in Column B Bold then the next 4 cells red so on... Thank You

Hello All, I'm having issues with syntax to recognize Bold Font, any style or size. I wish to delete all rows in the worksheet, if Column B has Bold font and Column C has the number 0. I believe I have the Last Row part of it, I just need help with recognizing Bold Font. Thanks for the help

I'm trying to move only cells in column C that are bold to the adjacent cell B, then plus one roll down so that they align with the non bold text beside it Ex: C1 Bold Text Here C2 Non Bold Text Here C3 Bold Text Here C4 Non Bold Text Here So, I need to get C1 moved to B2, and C3 moved to B4...

I am trying to sum the products of a cell in a few sheets, based on various arrays...needless to say, it wont work... this is what i've got...

The sheet's name is: animals A B 1. lion The lions are beatufil animals. 2. dog Dogland is the home of the animals. I need a VBA code which examines the words in column "A" and notes the first...

Hi I have a pivot table with just 2 columns. The Data set, about 50k+ rows, is also the source for other tables. Column 1 is a component Part No. while Column 2 is a list of products in which this component is used. Setting up the table was no problem. Both columns are "Row Labels". The...

Can anyone post a reference for the code needed to create an email message from excel? I am able to populate an email message with words but I am wondering if there is a way to make certain words Bold, or how to space down to the next line, different size font, etc???

I’ve been learning word mail merge with excel. The question is how to get the merge fields in bold and italics but for only one single cell. When I apply bold formatting it formats all of the merged items at once. I only want one to be bolded and one with italics

Hello, I have a userform with a multipage control on it. This Multipage has two pages (Page1 & Page2). How to bold the caption of Page1 when Page1 is activated, and formatting regular the caption of Page2 since Page1 is actived? Thank you

Hello, I'm working with 3D Surface Charts using Personal Macro WB. The 3D chart is in a Chart Sheet and NOT embedded. I need to put the LegendEntry(12) text into a variable. I can Bold the text using ActiveChart.Legend.LegendEntries(12).Font.Bold = True But I can't figure out how to retrieve...

Hello, I like to extract 8 characters from a string in cell X. Strings are different lenght but last 10 chars ale always 10. I need 8 chars before last 10. example string and what I need to extract (in bold) random_name_some_data-123456782017121299P Please help :) Best Regards W.