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

Protect Range of Rows and Columns in Worksheet with Macro

April 4, 2009 by vba excel · 1 Comment
Filed under: Excel Vba, Excel Worksheet 

Excel Vba Protect Range of Rows and Columns in Worksheet with Macro [Q]

I need help in protecting a range of rows and columns with excel vba macro code in Excel
worksheet. An Excel Workbook contains 14 worksheets (12 for..... Read The Solution..

Code to Skip a Row in Worksheet

April 2, 2009 by vba excel · Leave a Comment
Filed under: Excel Vba, Excel Worksheet 

Excel Vba Code to Skip a Row in Worksheet [Q] :

In the following excel vba macro to generate a report on a worksheet. I would like to have an empty excel row between the generated data rows.
Can I also assign a pointer t..... Read The Solution..