Search results 60

  2. Search results
  3. sheet name
Sorted from new to old.
Card image
ConditionalFormatting_Clear

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

Nov10
Card image
ANmaRead_1stFile

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

Aug11
Card image
ANmaCellFormat

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

Apr18
Card image
SortArea4

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

Apr15
Card image
ChartLabelsNumberFormat

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

2023Dec23
Card image
ANmaPivotTable_Clear

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

2023Dec22
Card image
PrCal_Add_Sort

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

2023Dec2
Card image
List_of_Names + DeleteNames

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

2023Jul9
Card image
Excel user name

Get application user name or change it Originally from

2023Jun14
Card image
Filename_Clean

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

2023Jan11
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22
Card image
Shape_Select_or_CreateThenSelect

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

2022Jul21
Card image
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19
Card image
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3
Card image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16
1234