Search results 128

Sorted from new to old.

ChartLabelsNumberFormat

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

2023Dec23

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

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HTML2Str

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

2023Nov5

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

1 2 3 ...7 8