Search results 732

Sorted from new to old.

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Mon 1PM

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Mon 1PM

MathInsideText

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

Thu 1PM

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

May4

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

NumberBeforeString

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

Apr10

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

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

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

Mar13

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

1 2 ...45 46