Search results 36

Sorted from new to old.

Icon as text - CmdCaption_ChrW

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

2025Jul17

Custom Excel UI ribbon

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

2025May11

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

1 2 3