Sharkky
July 29th, 2003, 05:34 PM
What is a problem:
1. I need to copy cells from one worksheet to another, but I need to copy not only values of cells but its ?????????? too
to copy them at general
2. If I read a worksheet and a row has such format, so it is an usual row. But if it has another format, so it is ????????? and I
should operate with it by specila way. So I need to compare "format"
It would be amazing... if Range object had something like Format property, what consist ofall the things like color, font, borders e.t.c. But there isn't such property. There is FormatConditions property. It looks like our "virtual format" by the meaning, but I don't really understand how do it work. And the FormatConsitions property is read only, so it's impossible to orginize copy procedure with it.
Actually the thing what I'm trying to name "Format" consist of three things: Interior, Font and Borders. All elements of Borders
collection are read only also. So, I need to copy each property manually to orginize copy procedure. But I think, that it could exist more clever way to act. And May be I don't understans something in this question?
Write me, please!!!
1. I need to copy cells from one worksheet to another, but I need to copy not only values of cells but its ?????????? too
to copy them at general
2. If I read a worksheet and a row has such format, so it is an usual row. But if it has another format, so it is ????????? and I
should operate with it by specila way. So I need to compare "format"
It would be amazing... if Range object had something like Format property, what consist ofall the things like color, font, borders e.t.c. But there isn't such property. There is FormatConditions property. It looks like our "virtual format" by the meaning, but I don't really understand how do it work. And the FormatConsitions property is read only, so it's impossible to orginize copy procedure with it.
Actually the thing what I'm trying to name "Format" consist of three things: Interior, Font and Borders. All elements of Borders
collection are read only also. So, I need to copy each property manually to orginize copy procedure. But I think, that it could exist more clever way to act. And May be I don't understans something in this question?
Write me, please!!!