Search results 172

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

2025Jul17

Non-English IDNs

Online tool to encode or decode IDNs Domain names with characters other than ...

2025Jun4

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

2025Mar12

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

HTML_CleanNumber

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

2024Jan31

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

ChartLegendCenter

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

2023Dec21

SQL Date from DateTime

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

2023Nov29

1 2 ...10 11