MyDevLib

Search results 71

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

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

2023Mar31

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

2023Mar6

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

2022Aug31

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

2022Aug22

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

2022Aug16

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

2022May16

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

2022Jan28

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

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

2021Oct13