Search results 60

Sorted from new to old.

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Webfont generater

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

2023Nov27

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

Can't find Project or Library

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

2023Sep1

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

1 2 3 4