Search results 61

Sorted from new to old.

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

TrimLines

Remove all line breaks from text from a text. Not like

2025Jan31

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

Popup button

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

2022Oct13

Dropdown button commands

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

2022Oct12

LastRow_Remove

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

2022Aug16

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

1 2 3 4