Search results 56

Sorted from new to old.

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

Sep30

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Mar5

Excel clipboard bug

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

2023Dec27

Macro keyboard shortcuts

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

2023Dec13

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

1 2 3 4