Tag Archives: excel vba

Get Position of Last Column Containing Data with Excel VBA

Posted on June 13, 2009 by Admin

If you read my latest update on how we can get position of last row containing data, then most probably you already have a glimpse on how we perform the same task with last column containing data in Excel. The … Continue reading →

Posted in Cells and Range | Tagged , , , , , , , , | 1,216 Comments

Move Cursor To One Cell Below Last Row With Data

Posted on October 15, 2008 by Admin

Ever want to paste some data into new empty cell after the last cell with data in certain column? Then take a look at this simple macro. ‘first, select cell in the first row of that column, like A1, K1, … Continue reading →

Posted in Excel VBA Function | Tagged , , , , , , , , , , , | 971 Comments

How To Hide an Excel Worksheet

Posted on September 24, 2008 by Admin

Some time we want to hide a certain Excel Worksheet from view, and it’s a common practice to use select the Worksheet, go to menu Format > Sheet > Hide. Using the method explained above is right, but unfortunately, others … Continue reading →

Posted in Workbook and Worksheet | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 1,987 Comments