Search results 60

Sorted from new to old.

Special chars

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

2021Oct13

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

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

Add2Column

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

2020Jan3

Copy formulas

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

2019Oct3

jui_datagrid

JavaScript driven data grid component

2019Sep15

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

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

2018Aug25

1 2 3 4