Search results 60

  2. Search results
  3. ShIn sheet name in VBE
Sorted from new to old.
Card image
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22
Card image
ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4
Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5
Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23
Card image
HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30
Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29
Card image
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22
Card image
ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5
Card image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11
Card image
Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11
Card image
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3
Card image
NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21
Card image
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22
Card image
WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3
Card image
Refreshing image

Refreshing image in ImageControl of VBE Userform When we change picture of ...

2020Feb3
Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3
1234