Search Sheet Area

Finds an entry in a sheet area.

Parameters

• Search text - Text (or number) to find
• Spreadsheet - Search from this sheet location [c,r] = [left,top]
• Columns - Number of Columns in the area
• Rows - Number of Rows in the area
• Returned Column Number - Global Data Item that receives Column Number (or zero if not found)
• Returned Row Number - Global Data Item that receives Row Number (or zero if not found)

• Copy Sheet Area
• Copy Sheet Column
• Copy Sheet Row
• Count Sheet Area
• Count Sheet Area Non Zero
• Sum Sheet Area
• Clear Sheet
• Clear Sheet Area
• Clear Sheet Data Only
• Insert Row
• Insert Column
• Insert Cell Vertical
• Insert Cell Horizontal
• Delete Row
• Delete Column
• Delete Cell Vertical
• Delete Cell Horizontal

• Simul8 Spreadsheets