Search results 60

  2. Search results
  3. list of rows
Sorted from new to old.
Card image cap
Most recent in Oracle DB

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

2020Feb7
Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3
Card image cap
Add2Column

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

2020Jan3
Card image cap
all_tab_columns

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

2019Dec22
Card image cap
Copy formulas

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

2019Oct3
Card image cap
Country list in arabic

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

2019Sep9
Card image cap
CountArrayCol

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

2019Aug9
Card image cap
CopyRowHeight

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

2019Aug1
Card image cap
Rows 2 Cell

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

2019Jul30
Card image cap
KeyASCII

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

2019Apr27
Card image cap
ExportSheets_to_1PDF

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

2018Aug8
Card image cap
CreateZipFiles_7Zip

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

2018Jul14
Card image cap
SplitTo2DArray

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

2018Jul9
Card image cap
FormulasFlatten

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

2018Jun30
Card image cap
CellRead (SimpleLookup)

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

2018Jun25
Card image cap
RowsCount

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

2018Jun22
1234