Search results 242

Sorted from new to old.

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Convert_Dash_to_Zero

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

2023Mar14

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range2Block

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

2023Mar6

Windows Common Controls 6.0

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

2023Feb19

ANStr2Range

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

2022Nov11

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

AddDatabar_ConditionalFormatting

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

2022Aug22

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

LastRow_Remove

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

2022Aug16

SmartMenus for WordPress

Cascading menu, on all devices. From ...

2022Jul11

Export2CSV

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

2022May16

ASPUsers

Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...

2022May4

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

1 2 ...8 ...15 16