Skip to Content
author's profile photo Former Member
Former Member

Formatting Multiple EVDRE

Hi,

I'm using more than one evdre() on one single sheet. Column structure of all evdres is same that's why I'm just appending rows of one evdre beneath the other.

Strangely each set of rows considers its preceding evdre's set of rows as Header. And subsequently all formatting goes wrong.

Could you please tell me:

- why every new evdre's rows consider the above as header?

- how to deal with the formatting in this scenario?

Many thanks,

Shabbar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 11:07 PM

    It is hard to assess without a visual, but I think I understand the question. I assume you have a single COLUMN KEY RANGE that is used for all the EVDREs? If it is true, then from the KEY range to the data range, that section applies FORMATS based on the last section of expansion data accross the rows from the col key range to the last data dre section. If each EVDRE has its own formatting applied, then each evdre needs its own col key range directly above the data range, so as to apply the formats for each expansion correctly.

    Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2009 at 11:45 AM

    Hi,

    I would suggest you to use Multiple row key Ranges instead of multiple EVDRE's if possible. ssue

    And for your formating issue,

    Any thing between the Key Range and Data Range is considered as Headers. One easy way to solve this issue is include the Header formating for COL's only for the 1st EVDRE and for other EVDRE's include all other formatings.

    If you are using Same formate range for all the EVDRE's, include the COL HEADER formating as your last line in the format range and include this line in formate range of 1st EVDRE alone.

    Hope this helps,

    Kranthi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.