Search results 100

Sorted from new to old.

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

1 2 3 ...6 7