Search results 23

Sorted from new to old.

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Oct31

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

ImportCSVs - 1st AI Code

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

2023Mar20

Old cell value

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

2021Dec30

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

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

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

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

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

1 2