Search results 216

Sorted from new to old.

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

ANmaCopy_Objects

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

2020Nov11

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Paste into textbox

Paste text from clipboard into textbox

2020Oct11

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

2020Aug16

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

2020Feb1

1 2 ...8 ...13 14