Question

5. What do you use to access cells in a worksheet within a VBA code?

Answer 1

5) In excel, The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook. The Worksheet object is also a member of the Sheets collection. The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets). Access cells in worksheet Because the default member of Range forwards calls with parameters to the Item property, you can specify the row and column index immediately after the Cells keyword instead of an explicit call to Item. Using this property without an object qualifier returns a Range object that represents all the cells on the active worksheet. Examples This example sets the font size for cell c5 on Sheet2 of the active workbook to 09 points. Worksheets("Sheet2").Cells(5, 3).Font.Size = 09 Therefore Answer is Cells([Rowindex], [Columnindex])

Hope this helps

All the best :)