Search results for query: *

You'll need to add the RTF encoding to the ASCII strings you're working with. Or maybe you can read the RTF template inclusive of encoding, then change only the text and drop the whole thing back in. https://en.m.wikipedia.org/wiki/Rich_Text_Format

How and where would one use that?

G HCode

Oh! Grids!

Too bad, can't drag and drop arbitrary file types to attach. Can't use the Attach files button to attach arbitrary files. Only a limited set of file types allowed.

Just drag and drop and image, nice!

Radiology

Valid

"Only rectangular clumps are counted." Too bad. So, it seems that you'll need to write your own function that loops through each cell in the range and tests each of the cell's eight neighbors for AND(your condition, inside the range)

As a starting concept: Public Function MakeArea(Target As Range, Test As Integer) As Range Dim myArea As Range Set myArea = Nothing For Each myCell In Target If myCell.Value = Test Then If myArea Is Nothing Then Set myArea = myCell End If Set myArea =...

Mandraulic, that's a new word for me!

= COUNTBLANK( $A$1:$E$5 B2:F6)+COUNTA( $A$1:$E$5 B2:F6) Works for me. COUNTBLANK() counts the blank cells and COUNTA() counts the not empty cells In older versions of Excel you might need to force that as an array formula by using cntrl+shift+enter Newer version automatically make array...

I rarely find tutorials motivating. They're typically trivial examples, and of no relevance to me. I prefer to wait for a need, start with the assumption that "there must be a way to use the tool", and figure out the solution. In my particular case, I was building a project estimating...

I've just made my first venture into using Power Query after years of procrastinating. All I want to say is Wow! Why haven't I been using this all these years.

@combo Thanks, that works. I had tried something similar earlier, but it missed the need to Set the final value because it's an object. Set GetPivotTopLeft = PT.TableRange1.Cells(1)

Excel provides the GETPIVOTDATA() function. GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...) Microsoft defines the pivot_table parameter this way: "A reference to any cell, range of cells, or named range of cells in a PivotTable. This information is used to determine...

Then you need to use .HTMLbody instead of .body

mySig = .body .body = "some body text" & mySig

Seriously? You can't figure that out by yourself? You can't even try something?