Profile cover photo
Profile photo
Struggling to Excel
92 followers -
Struggle lesser everyday!
Struggle lesser everyday!

92 followers
About
Posts

Post has attachment
Excel’s Application object’s WorksheetFunction property is a container for Microsoft Excel worksheet function. This property returns a WorksheetFunction object that allows VBA access to the rich set of functions that are built into Excel. While VBA has…
Add a comment...

Post has attachment
Have you ever felt Excel needed a Fit-Document-to-Window-Width feature like the millions of PDF Readers out there? Wouldn’t it be great if you could automatically fit your document to your current window size? The irony is, Excel already has all it needs…
Add a comment...

Post has attachment
Duplicate a Sheet and retain a reference to it in #Excel #VBA

I recently worked on a project where my client had a Master template-sheet that needed to be duplicated and populated repeatedly. I needed to duplicate a sheet, and retain a reference to it, so I can rename it, reposition it, and pass it to another sub…
Add a comment...

Post has shared content
This post is about getting the user's permission before running a procedure, using the MsgBox function.

Post has shared content
This post is about getting the user's permission before running a procedure, using the MsgBox function.

Post has attachment
In this post, I describe a quick way to list all the DAX formulas in your PowerPivot for Excel 2010 Data model.
Add a comment...

Post has attachment
This post is about getting the user's permission before running a procedure, using the MsgBox function.
Add a comment...

Post has attachment
When to use the Sheets Collection in #Excel #VBA?

There are two collections in Excel-VBA that lets the user access sheets in a workbook: the Sheets collection and the Worksheets collection. You can use these collections interchangeably in most situations, but they were each created for a specific…
Add a comment...

Post has attachment
I gave my blog a new look to go with the domain name! Check it out and let me know what you think!
Add a comment...
Wait while more posts are being loaded