Search results 265

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...

Sep30

UnicodeToChrW

Converts a unicode number into its ChrW text. It automatically uses surrogate ...

Jul17

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

May26

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

NumberBeforeString

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

Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

Apr2

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Mar24

NumberBeforeString_HTML2

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

Mar20

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11

1 2 ...16 17