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
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

code image
Pps vs ppsx

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

2020Dec20

code image
Card2-BS3

Colorful card with ribbon, custom and can be used as product or promotion

2019Feb13

code image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27