Search results 94

Sorted from new to old.

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

Add2Column

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

2020Jan3

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

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

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

SheetName

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

2018Aug23

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

1 2 ...4 5 6