Search results 65

Sorted from new to old.
Card image
Pagebreak and Pagebreak preview

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

Card image
Shapes_HideShow

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

Card image
ANStrVLookupAll

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

Card image
MatchIf8

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

Card image
ANmaRename2Files

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

Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Card image
VBInstr_Occurance

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

Card image
ConditionalFormatting_Clear

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

Card image
ANmaRead_1stFile

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

Card image
ANmaCellChar_Superscript_Subscript

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

Card image
Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Card image
Center Userform

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

Card image
MatchIf6Up

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

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...