Skip to main content

[archive] Need some help translating vb to cobol4

  • September 23, 2009
  • 2 replies
  • 0 views
D

[Migrated content. Thread originally posted on 15 September 2009]

Hello,

i want to set the background color of a column until the last filled row.

Range("E1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Interior.ColorIndex = 6

Thanks

Oliver

    2 replies

    D

    [Migrated content. Thread originally posted on 15 September 2009]

    Hello,

    i want to set the background color of a column until the last filled row.

    Range("E1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Interior.ColorIndex = 6

    Thanks

    Oliver
    copy paste from code i used sometimes ago...


               inquire xls-sheet @CELLS::@RANGE(s-range, e-range) xls-range.
               modify  xls-range @SELECT().
               modify  xls-range @INTERIOR::@COLORINDEX = 15.
    D

    [Migrated content. Thread originally posted on 15 September 2009]

    Hello,

    i want to set the background color of a column until the last filled row.

    Range("E1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Interior.ColorIndex = 6

    Thanks

    Oliver
    Danke :)
    Thanks

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement