Search results 74

Sorted from new to old.

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

ReadBinaryBuffer

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

2023Apr30

ScanFolder

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

2023Apr7

Excel recovered files

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

2023Mar31

Range2Block

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

2023Mar6

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

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

UISetup + UIRestore

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

2022Jan28

InStr and InStrRev

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

2021Dec6

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

1 2 3 4 5