underline

Dear all, I currently have this code: However, it seems that me highlighting it with bold and underlining it through the use of "<b><u>" (which has worked for me before), does not work anymore. Does anybody have any idea how I can either fix or change my code? It would be greatly...

Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...

Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...

Is it possible to format half of a cell with a different format? I'm using =TEXT(G5,"0.00")&CHAR(10)&TEXT(E5,"0.00") and would like to format the first half with an underline so it looks like a division. Like this 1267.98 66.21

How can I underline or highlight spelling errors as I am entering text data ? Can I do this without a script? If so please tell me how. If I need a script THANK YOU IN ADVANCE if you would kindly share it with me. Thanks

Is there a number format or conditional formatting that can pad any alphanumeric value with spaces? I create a lot of Excel Forms. I want the empty cell to display as underline and I want the underline to show the full width of the cell. I know I can put spaces in the cell and it will show...

How do I write an if statement that says if cell d10 doesn't match cell d9, then underline the entire row, then go to the next cell until there is nothing in a cell.

Hey all, I would like to underline the value in selected cell using conditional formatting along with Application.Calculate method. I have achieved this with formatting the row and column with formula's such as =COLUMN()=CELL("col") =CELL("row")=ROW() =$A$1:$DZ$1 =$A$1:$A$600 respectively...

I have a very simple VBA sub which is intended to underline a worksheet at each page break when printed. The total length of the worksheet is 3574 rows. The sub works fine down to row number 1477 but then gives an error message "subscript out of range". I have used this in the past on Excel 2007...

In Column B is a concequtive list of numbers from 1000000 to 7000000. Want to insert a underline border in column A to H the first time the number is above 3999999. (This is part of a vba formatting mode) Column B is a list of account numbers. Not sure the specific account 3.999.999 exists...

In column C is a list of account numbers. After account 4999999, I want to insert a thick black underline from column B to K. Is it possible to write VBA code for this.

I have an excel sheet that is exported from an access report. The excel file automatically resizes columns and wraps text, etc. One of the columns on this sheet contains about a paragraph's worth of information. My question is: is it possible to somehow format all cells in this (or all)...

I have a cell containing a paragraph of text. When I go to underline a portion of that text, only the words are underlined and not the spaces. Is there a way to underline the entire phrase instead of just the words? What it does: The quick brown fox ran and jumped over the white fence. What I...

The formula is ="Total: " &SUM(B2:B10) Can you make the result appear bolded and underline. Just the result from the =SUM formula not the text Total.