VBA-Excel 280 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
ConcatenateStrings_AmongString

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

Card image cap
Frm58

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

Frm58.zip

Card image cap
ChartLabelsNumberFormat

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

Card image cap
ANmaPivotTable_Clear

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

Card image cap
ChartLegendCenter

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

Card image cap
Macro keyboard shortcuts

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

Card image cap
PrCal_Add_Sort

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

Card image cap
UserChanged_Log4

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

Card image cap
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Card image cap
HTML2Str

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

Card image cap
AddressReferenceStyle

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

Card image cap
ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...