Search results 183

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30

Site as app (PWA)

Instructions on how to convert a website into an app, called Progressive Web ...

2025Jun19

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

CSS Generators

One of my newest friends in css styling, tons of options. Love the simple ...

2025May22

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

2025May13

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

2024Nov7

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

1 2 ...11 12