Search results 38

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

Shapes_HideShow

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

2025Sep30

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

Antispam - Hiding textbox

Anti spam email web form idea.

2022Nov14

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

1 2 3