Search results 60

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

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

Calculation_StaleValues

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

2025Jun30

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

2024Aug19

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

2024Aug6

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

1 2 3 4