Search results 60

  2. Search results
  3. ShIn sheet name in VBE
Sorted from new to old.
Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM
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
EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25
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
Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17
Card image
List_of_Names + DeleteNames

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

2023Jul9
Card image
FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7
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
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
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image
Export2CSV

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

2022May16
Card image
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22
1234