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
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.
"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 =...
= 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.