Search results 181

Sorted from new to old.

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

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

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

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

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

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

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

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

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

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

1 2 ...7 ...11 12