Browse codes

Components 83 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Get total number of rows for a certain worksheet in certain workbook workbook ...

6/22/2018 5:22:00 PM

Returns true if VBA is accessible through code, returns false if not

6/22/2018 4:55:00 PM

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

6/18/2018 5:43:00 PM

Check if an Excel file is running from 'Temp' location or regular folder This ...

6/17/2018 12:34:00 PM

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

6/17/2018 12:19:00 PM

Searches for an item in a column, then if found, delete that cell (not clear, ...

6/17/2018 11:26:00 AM

Reads a value giving column, row, sheet and workbook name Accepts D+R to ...

6/16/2018 9:32:00 PM

Matching 4 values at the same time in 4 columns Just like Match the function, ...

6/16/2018 8:48:00 PM

Matching three values at the same time in three columns Just like Match the ...

6/16/2018 8:44:00 PM

Matching by two values at the same time in two columns Just like Match the ...

6/16/2018 8:41:00 PM

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

6/16/2018 8:34:00 PM

The best Match I created, return 0 if not found, kind of CountIF+Match ...

6/16/2018 8:32:00 PM