Posted By

laurenceosx on 07/22/09


Tagged

ResolverOne


Versions (?)

ResolverOne Easy Cell Ranges


 / Published in: Python
 

URL: http://www.resolverhacks.net/easy_cellranges.html

  1. def CellRangeFromDimensions(startCell, width, height):
  2. endCell = startCell.Offset(width-1, height-1)
  3. return CellRange(startCell, endCell)
  4.  
  5. def FormatCellRangeBorders(cellRange):
  6. cellRange.BorderRight = True
  7. cellRange.BorderTop = True
  8. cellRange.Cols[1].BorderLeft = True
  9. cellRange.Rows[cellRange.MaxRow].BorderBottom = True

Report this snippet  

You need to login to post a comment.