Copy Entire Rows to Another Spreadsheet Based on Cell Criteria

September 29, 2009 by vba excel · 4 Comments
Filed under: Excel Spreadsheet, Excel Vba 

Excel Vba Copy Entire Rows to Another Spreadsheet Based on Cell Criteria [Q]

I am looking for excel vba codes to copy rows based on partial cell content. I have an excel spreadsheet called “main.xls” from which I w..... Read The Solution..

Using Relative Excel Spreadsheet References in Vba macro

July 20, 2009 by vba excel · 2 Comments
Filed under: Excel Spreadsheet, Excel Vba 

Excel Vba Using Relative Excel Spreadsheet References in Vba macro [Q]
I want to move the contents of excel spreadsheet cell (in an array) when I know its column and relative row number using excel vba macro. The requested cell..... Read The Solution..

Saving Excel File with Name and Date Details

July 20, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Saving Excel File with Name and Date Details [Q]
I need excel tips to save Microsoft excel file I am working on (template) with the name of
the file and the date?

ex. “filename - 2008-10-29.xlsR..... Read The Solution..

Embedded Chart on Worksheet Using Excel Vba

April 23, 2009 by vba excel · 2 Comments
Filed under: Excel Vba, Excel Worksheet 

Embedded Chart on Worksheet Using Excel Vba [Q]


Hi, i have an excel button command that brings a embedded chart onto my excel worksheet, it works fine, so i wanted to write a simple excel macro to assig..... Read The Solution..

Excel Time Macros on Weekday Only

April 22, 2009 by vba excel · Leave a Comment
Filed under: Excel Spreadsheet, Excel Vba 

Excel Vba Time Macros on Weekday Only [Q]

Ive a problem when setting time macros on weekday using microsoft excel vba. How to set the time macro. I want to set a time macro which only run on specified time on weekday only in e..... Read The Solution..

Next Page »