Hi Yuri,

Thanks to YOU ,I got everything working on my excel sheet except the followings.

*--- Need to make the font Bold and I tried


With oExcel && oExcel is my App object

.Range("D7").Select
.Selection.Font.Bold = True && Got an error message here

Endwith


*-- Need to sum Q1 column data and store the total at the bottom of the column .

HOW ?????

I’m not very much familiar with VBA and I just tried to record some macros and get the syntax. Didn’t work out that good.

Please Help !!!

- Jeana -