MyDev

Search results 146

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

2023Dec23

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

2023Dec22

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

2023Dec21

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

2023Dec2

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

2023Nov28

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13