Search results 37

Sorted from new to old.

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

Nov11

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

img disable

Disable html img actions in website, like right-click menu, dragging and others. ...

2024Dec17

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

bootstrap-linkpreview

Preview link js script uses jquery and bootstrap From

2023Nov3

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 3