Codes Required

Similar codes

code image
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

code image
Excel clipboard bug

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

2023Dec27

code image
Copy formulas

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

2019Oct3

code image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

code image
Rename File

This will rename a specific file and or move the file to a different directory

2018Apr16

code image
RangeValues

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

2024Jan25

code image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

code image
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

code image
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

Recently by developer

code image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

code image
TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Random Codes

code image
ShapeRange_BG

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

2021Mar27

code image
Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image

2019Apr9

code image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

code image
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30