Search results 60

Sorted from new to old.

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

KeyASCII

KeyASCII list, I often need that in my projects. List of ASCII codes 1 to 256

2019Apr27

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

1 2 3 4