Search results 60

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...

Sep30

ShapeCreate_SomeVariables

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

Sep30

Shapes_HideShow

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

Sep30

Custom Excel UI ribbon

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

May11

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

Excel 2408 bug

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

2024Sep10

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

VBInstrRev

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

2024Jan24

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

SheetTabColor

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

2023Aug17

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

SubZero

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

2023May23

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

2023Apr5

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

1 2 3 4