Search results 547

Sorted from new to old.

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Jan28

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

Jan16

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

Jan4

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

1 2 3 ...34 35