Search results 58

Sorted from new to old.

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

May1

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

Walking Columns (Scrollable Columns-Chart)

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

2024Sep30

ANmaFiles2List

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

2024Sep21

Just learnt that now

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

2024Mar5

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

1 2 3 4