Search results 146

Sorted from new to old.

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Match4_Until

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

2024Nov22

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

ConditionalFormatting_ColorARow

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

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

Center Userform

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

2024Jul23

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

Mini Ajax-php upload form

Simple elegant form to upload files with php/ajax. From

2024Feb15

NumberBeforeString

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

2024Feb1

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

1 2 ...9 10