Search results 57

Sorted from new to old.

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Custom Excel Right-Click Menus

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

2020Mar21

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

Anticipate WP

Under Construction plugin for wp

2019Apr29

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

1 2 3 4