Search results 261

Sorted from new to old.
Card image
ListItemText_to_ListIndex

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

Card image
NumberBeforeString_HTML2

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

Card image
TemplateLine_10Xs

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

Card image
VBA/Excel Registry hacks

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

Card image
ListBox_Read and ListBox_Save

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

Card image
HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Card image
ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Card image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

Card image
HTMLCloseTag_HasWordAfter

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

Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Card image
ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Card image
FixURL

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

Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Card image
CutString12

Cuts string between two numbers that found inside string. Like extract the ...