Search results 21

Sorted from new to old.

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Win95 CSS

Win95 theme CSS with Bootstrap 4 From

2023May14

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ScrapeURL_ToSheet

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

2023Apr4

Zip_Folder

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

2023Mar29

DynamicFill

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

2022Mar11

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

Windows-like drop down menu

Classic-Windows-like dropdown menu using CSS and JS, library in zip is build in ...

2020Aug20

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

getDaysInMonth

Gets number of days in a certain month

2018Jul15

1 2