Search results 17

Sorted from new to old.

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

CellSave and CellRead

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

2020Oct31

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

UnMergeFill

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

2019Apr16

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

SheetDelete_ANmar

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

2018Aug9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

1 2