Search results 62

Sorted from new to old.

Pagebreak and Pagebreak preview

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

2025Nov11

Shapes_HideShow

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

2025Sep30

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

Center Userform

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

2024Jul23

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

VLookup_HTML

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

2024Jan26

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

ReplaceStrings

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

2023Nov11

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

1 2 3 4