Search results 225

Sorted from new to old.

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

SheetTabColor

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

2023Aug17

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Fix Excel Issue

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

2023Aug1

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

EmailSend_Outlook

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

2023Apr5

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

2023Mar29

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

1 2 ...4 ...14 15