Board index » delphi » Combine Excel Cells into one cell?

Combine Excel Cells into one cell?

I'm using Delphi5 and Excel2000. How can I combine some cells into on big
cell?

Thanks.

Steven Cheng

 

Re:Combine Excel Cells into one cell?


Range interface have a Merge method

--
With best regards, Mike Shkolnik
E-mail: mshkol...@scalabium.com
WEB: http://www.scalabium.com

Quote
"Steven Cheng" <steven_ch...@hongkongconcrete.com.hk> wrote in message

news:3e85195d@newsgroups.borland.com...
Quote
> I'm using Delphi5 and Excel2000. How can I combine some cells into on big
> cell?

> Thanks.

> Steven Cheng

Re:Combine Excel Cells into one cell?


How to set a formula in a cell?

Thanks.

Steven Cheng
"Mike Shkolnik" <mshkolnik2...@ukr.net> ???g??l
news:3e857f00@newsgroups.borland.com...

Quote
> Range interface have a Merge method

> --
> With best regards, Mike Shkolnik
> E-mail: mshkol...@scalabium.com
> WEB: http://www.scalabium.com

> "Steven Cheng" <steven_ch...@hongkongconcrete.com.hk> wrote in message
> news:3e85195d@newsgroups.borland.com...
> > I'm using Delphi5 and Excel2000. How can I combine some cells into on
big
> > cell?

> > Thanks.

> > Steven Cheng

Re:Combine Excel Cells into one cell?


xls.ActiveSheet.Cells[ARow, ACol].Range.Formula := '=RAND()';

--
With best regards, Mike Shkolnik
EMail: mshkol...@scalabium.com
http://www.scalabium.com

"Steven Cheng" <steven_ch...@hongkongconcrete.com.hk> ???Y/???Y
????? ???Y??: news:3e8798a0$1@newsgroups.borland.com...

Quote
> How to set a formula in a cell?

> Thanks.

> Steven Cheng
> "Mike Shkolnik" <mshkolnik2...@ukr.net> ???g??l
> news:3e857f00@newsgroups.borland.com...
> > Range interface have a Merge method

> > --
> > With best regards, Mike Shkolnik
> > E-mail: mshkol...@scalabium.com
> > WEB: http://www.scalabium.com

> > "Steven Cheng" <steven_ch...@hongkongconcrete.com.hk> wrote in message
> > news:3e85195d@newsgroups.borland.com...
> > > I'm using Delphi5 and Excel2000. How can I combine some cells into on
> big
> > > cell?

> > > Thanks.

> > > Steven Cheng

Other Threads