Search results 463

Sorted from new to old.
Card image
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

Card image
Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image
Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image
UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

Card image
File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...