VBA-Excel 362

Visual basic for applications that works only in Microsoft Excel, aka macros

Sorted from new to old.

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

2018Aug14

Styles_DeleteNonStandard

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

2018Aug12

Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

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

SheetDelete_ANmar

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

2018Aug9

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

InternationalComma

Convert an international numeric with , instead of . Into American style . ...

2018Aug8

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

2018Jul22

1 2 ...18 ...22 23