macro VBA PowerPoint calculating the MIN and MAX in a table

[romelsms1]

please tell me how to create a macro in power point for a table.

I try to change the font cell color for the highest and lowest no for each line

I use powerpoint 2003

 

[SkipVought]

Hi,

You don't want to make your table in Excel, where you have all the bells and whistles for this sort of thing, and THEN paste it as an OLE into your PPT?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[romelsms1]

yes I know that but I have to do it in power point

 

[Gruuuu]

Why is it that you have to do it in Powerpoint? It's much easier to code doing something in excel and pasting it into the PPT.

 

[SkipVought]

...but I have to do it in power point...

Is this a homework assignment?

It is best and accepted practice to use the best suited tool that you have available for the task at hand.

I'd NEVER try to use Excel to make a PRESENTATION.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

However, if, for whatever reason, you MUST, use the Watch Window in your macro and the Object Browser to determine what Table Object properties and methods are available in PP.

faq707-4594

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}