Search results 38

Sorted from new to old.

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

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

1 2 3