Search results 35

Sorted from new to old.

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

Bootstrap-Chosen

Drop-down select in bootstrap From

2019Jul31

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

RunRemote

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

2019Jan9

Wordpress drop-down menu

Add dropdown with User login, logout into menu. This code used to replace "nav. ...

2018Dec18

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

RowsCount

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

2018Jun22

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

1 2 3