Search results 234

Sorted from new to old.

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Jul10

Range().top below hidden rows

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

Jan13

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

VBInstr_Rev_Any

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

2025Apr11

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

2025Apr2

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13

1 2 ...14 15