Search results 68

Sorted from new to old.

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Mon 1PM

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

2024Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

2024Jul31

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

HTML2Str

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

2023Nov5

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

1 2 3 4 5