All articles with 'macro' Tag

Using Arrays To Update Table Columns

Published on Sep 16, 2013 in Automation, Excel Howtos, VBA Macros

Using Arrays To Update Table Columns We are creating a lot of reports everyday and these reports contain a lot of data which is presented in various styles as per the requirements. The data that allows us to create the reports is usually referred as raw data and in most of the cases is stored […]

Continue »

Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

Published on Jul 30, 2009 in VBA Macros
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

I am stuck with an excel problem and I need your help. While trying to insert an image in to my excel 2007 workbook using VBA I hit on this weird error and not able to use the ActiveSheet.Pictures.Insert method. Do you know why?

Continue »

Excel Links of the Week – What the heck happened to photographic fridays edition

Published on Oct 27, 2008 in excel links
Excel Links of the Week – What the heck happened to photographic fridays edition

Remember the photographic fridays? Some of you must be thinking whatever happened those posts? Well, my intention for writing those posts has been to get your feedback so that few of us can become better photographers. But flickr does a hell of better job for this than my little blog can. So I have decided […]

Continue »

Simple Todo List application using Excel – Download and become productive

Published on Oct 1, 2008 in Learn Excel
Simple Todo List application using Excel – Download and become productive

After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel. Since most of us use Excel on day to day basis, why not use it as a productivity application as well by keeping track of all the things we must do (TO DO List). When […]

Continue »

Microcharting in Excel – 7 Alternatives Reviewed

Published on Sep 5, 2008 in All Time Hits, Charts and Graphs, Featured, ideas, Learn Excel
Microcharting in Excel – 7 Alternatives Reviewed

With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. […]

Continue »

Create Cool Tag Clouds in Excel using VBA

Published on Apr 22, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology

I was toying with the idea of creating a tag cloud in excel – as a form of new visualization, this could be useful when you have medium amounts of data (eg: 50-300 rows) and you want to emphasize on what is important and what is not. I would imagine using a tag-cloud, When you […]

Continue »