Search results 81

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

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

2025Jul17

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

2025May4

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

2024Aug15

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

Center Userform

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

2024Jul23

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

1 2 ...5 6