Search results 152

Sorted from new to old.

ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

2019Oct22

Copy formulas

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

2019Oct3

jExcel

jQuery plugin to embed a spreadsheet, compatible with Excel, in your browser. ...

2019Oct3

Tabulator

A nice, advanced powerful table control in js From

2019Sep18

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

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

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

Detect if Browser supports Flash

Detect if Browser supports Flash or not ( using ShockwaveFlash.ShockwaveFlash) ...

2019Jun2

Yamm3 mega menu

A bootstrap mega menu Demo:

2019May12

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

Service cards

Service cards in Bootstrap3, simple, and customizable. From Bootsnipp

2019Feb7

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

1 2 ...7 ...9 10