Search results 286

Sorted from new to old.

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

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

ASP Classic Page Cache

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

2022May20

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

GetGroupMembers

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

2022Feb1

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

1 2 ...7 ...17 18