In need of help from you experts (VBA for excel)

[memarianm]

Hi,

I would like to ask the experts here about a problem I have encountered in writing my program in Visual Basic. The problem is that my program calculates and generates tables of numbers that stores them in excel files. These results are to be formatted nicely and printed out by the program like it is giving out a report of it's calculations. But the problem arises on formatting these excel file's different cells. Assigning the formats to cells one by one in the projects code takes a heck of along time. I have tried using templates for these excel files but the problem is that in templates specific cells have formats but results of my program vary in every run, so consecutive tables with different sizes are created in the excel file. I would highly appreciate your opinion on this problem on actually what would be the best approach in formatting these excel files. The tables all have the same format but different sizes. e.g. the header of each table is merged and shaded etc.

Thank you

P.S please let me know of any needed clarifications on the problem.

 

[Corticus]

I wish I knew the answer to your question...

But,
if your post this question here:
http://mrexcel.com/board/viewforum.php?forum=2&98085

you'll probably have better luck!

Welcome to the board!

Corticus