Search results 34

Sorted from new to old.

ConditionalFormatting_Clear

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

Nov10

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Oct24

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

ANmaPivotTable_Clear

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

2023Dec22

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

1 2 3