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..

Resize Range for Column in Workbook

June 23, 2009 by vba excel · 1 Comment
Filed under: Excel Spreadsheet, Excel Tips, Excel Worksheet 

Resize Range for Column in Workbook [Q]

I dont know how to resize range for column in excel workbook, i have four named ranges that relate to a column of data starting on row 1 going
to the end of the column data on my e..... Read The Solution..

Problem When Inserting Image or Picture Box

May 5, 2009 by vba excel · Leave a Comment
Filed under: Excel Spreadsheet, Excel Tips 

Problem When Inserting Image or Picture Box [Q]

Ive a problem when i try to insert/add image or picture box on my excel spreadsheet, I use the following code for a image or picture box to load an image file:

Private..... 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 »