• Home
  • Consulting
  • Contact
  • About

Struggling To Excel

Excel to the rescue

  • Categories :
  • all
  • Macros
  • User Defined Function
  • Tips and Tricks
  • Applications
  • Excel Fun
Linear view vs. Masonry View
How to deal with the Numbers Stored As Text Error in Excel?

How to deal with the Numbers Stored As Text Error in Excel?


How many times have you encountered the “Numbers Stored as text” error in your data sets? It interferes with your LOOKUP and MATCH […]

August 11, 2014 22
Magically Select All The Used Areas In A Sheet using VBA

Magically Select All The Used Areas In A Sheet using VBA


I recently published a post about automatically formatting a table in Excel using VBA. That got me thinking, how awesome it […]

June 15, 2014 14
Magically Format Tables in Excel using VBA

Magically Format Tables in Excel using VBA


Excel Tables make analyzing data, a breeze. It surprises me that it is not used as often as it should. It automatically […]

June 2, 2014 5
Get the Actual Used Range in a Spreadsheet

Get the Actual Used Range in a Spreadsheet


In one of my posts, I wrote about the UsedRange property of the Worksheet object. I use it in almost all […]

May 26, 2014 32
Prepare for the show: A framework for hiding rows and columns in your spreadsheet applications

Prepare for the show: A framework for hiding rows and columns in your spreadsheet applications


Hiding a bunch of rows and columns in a sheet before showing it to your boss is inevitable.  I insert […]

April 25, 2014 8

To Err is Excel, Handle your Errors with grace


Error handling is an important aspect of programming in VBA, especially if you are writing macros for other users. Unfortunately, many […]

April 15, 2014 10
Snakes in Excel, Lets Play!

Snakes in Excel, Lets Play!


The biggest downside to working in massive corporate offices is the locked down computer systems. There is no internet access, no games, […]

April 6, 2014 11
Progress Bar for all your excel Applications

Progress Bar for all your excel Applications


Excel is versatile by itself and VBA makes it even better by allowing us to do our own thing. Most […]

March 27, 2014 74
Mix And Match – Get all possible permutations of an unlimited number of lists in Excel

Mix And Match – Get all possible permutations of an unlimited number of lists in Excel


This post is a little fun, not much of a Struggle I guess. In excel, we use permutations more often […]

February 21, 2014 38
Concatenate Unique Cells, with Text Formatting

Concatenate Unique Cells, with Text Formatting


A fellow struggler requested me to help him with a slightly beefed up Range Concatenate function. He needed to combine a […]

February 18, 2014 7

Posts navigation

‹ Newer 1 2 3 4 Older ›

Blog Stats

  • 303,818 visits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,158 other followers

Wordpress.com

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Create a website or blog at WordPress.com
Cancel