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, ...

Thu 1PM

Match4_Until

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

Nov22

VBInstr_Any

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

Nov17

ConditionalFormatting_ColorARow

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

Nov10

ConditionalFormatting_Clear

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

Nov10

Sheet_RowID_Generate + _LastUsed

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

Nov3

ANmaRead_1stFile

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

Aug11

Center Userform

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

Jul23

ANmaSearch_AmpFriends

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

Jul7

SettingSave + SettingRead for NumberFormat

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

Apr19

ANmaCellFormat

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

Apr18

ListBox bug with TabIndex

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

Apr15

DateDateDate

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

Mar3

Mini Ajax-php upload form

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

Feb15

NumberBeforeString

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

Feb1

UnUnixDateTime

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

Jan6

1 2 ...9 10