Search results 346

  2. Search results
  3. this
Sorted from new to old.
Card image
Convert_Dash_to_Zero

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

2023Mar14
Card image
Range2Block

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

2023Mar6
Card image
Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19
Card image
NavigatePost

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

2023Jan14
Card image
File_SettingRead + File_SettingSave

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

2022Dec27
Card image
ANmaVLookup

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

2022Dec23
Card image
ANStr2Range

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

2022Nov11
Card image
Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13
Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12
Card image
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25
Card image
HyperlinkFunction

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

2022Aug24
Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22
Card image
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16
12...7...2122