Search results 60

Sorted from new to old.
Card image
Range().top below hidden rows

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

Card image
Textbox_PartialBold

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

Card image
Calculation_StaleValues

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

Card image
UsedRange

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

Card image
SettingRead_Bulk

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

Card image
Match3_3rdNot0

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

Card image
HTMLdd_Fromdt

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

Card image
ExtractNumeric_FromCell

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

Card image
ANstr_Column

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

Card image
Center Userform

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

Card image
SQL instr

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

Card image
Protect txt file into word doc with password

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

Card image
CutString7

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

Card image
Frm58

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

Card image
HMatchIf_Multi

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

Card image
End ( xlDown )

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