Search results 38

Sorted from new to old.

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

1 2 3