Search results 84

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image cap
WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Card image cap
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image cap
ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

Card image cap
ScrapeURL_ToSheet

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

Card image cap
Convert_Dash_to_Zero

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

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
ANmaVLookup

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

Card image cap
ANStr2Range

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

Card image cap
ANmaRemoveDuplicates

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

Card image cap
ANmAdvancedFilter

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

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...