Search results 78

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

Header font name and size in VBA

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

2025Jun1

MathInsideText

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

2025May8

Tabs-Auto-To-Menu

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

2025May4

ListItemText_to_ListIndex

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

2025Mar24

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

CutString96_NumberBefore and After

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

2024Nov24

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

IsNumericChar

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

2024Aug21

1 2 3 4 5