Page History

{description}
{excerpt}Defines a rectangular [Area|Area] of cells in the worksheet.{excerpt}
{signature:C#}
 public Area CreateArea(System.String areaFormula)
{signature}{signature:vb.net}
Public Function CreateArea(ByVal areaFormula As String) As Area
{signature}
{parameters}
{param:areaFormula}A formula representing the area, e.g. "A3:B5". The formula must be local to the worksheet and should not contain a sheet reference.{param}
{returns}An {{Area}} object.{returns}
{example}{code:csharp|title=C#}
Area a = ws.CreateArea("B7:H24");{code}
{code:vb.net|title=vb.net}
Dim a As Area = ws.CreateArea("B7:H24"){code}

{example}