Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

Frm58.zip

ChartLabelsNumberFormat

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

ANmaPivotTable_Clear

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

ChartLegendCenter

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

Macro keyboard shortcuts

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

PrCal_Add_Sort

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

UserChanged_Log4

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