Search results 134

Sorted from new to old.

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

Range22DimArray

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

2023May11

Zip_Folder

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

2023Mar29

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Convert_Dash_to_Zero

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

2023Mar14

Range2Block

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

2023Mar6

ANmaVLookup

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

2022Dec23

ANStr2Range

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

2022Nov11

AddDatabar_ConditionalFormatting

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

2022Aug22

LastRow_Remove

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

2022Aug16

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

1 2 3 ...8 9