Search results 61

Sorted from new to old.
Card image
Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Card image
Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Card image
MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

Card image
ANmaRename2Files

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

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
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

Card image
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Card image
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

Card image
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image
Excel user name

Get application user name or change it Originally from

Card image
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...