Search results 72

Sorted from new to old.

Excel clipboard bug

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

2023Dec27

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Bing Desktop wallpapers

Folder where

2021Mar5

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

1 2 3 4 5