Search results 208

Sorted from new to old.

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

Convert_Dash_to_Zero

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

2023Mar14

NavigatePost

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

2023Jan14

Filename_Clean

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

2023Jan11

UnixDateTimeNumber

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

2023Jan6

ANmaVLookup

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

2022Dec23

SwapNumbers

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

2022Oct17

ANmaRemoveDuplicates

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

2022Sep25

LastRow_Remove

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

2022Aug16

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

1 2 ...4 ...12 13