Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please explain how all answers were determined. Thank you. Questions are posed the way they are. If it is missing something, such as a code
Please explain how all answers were determined. Thank you. Questions are posed the way they are. If it is missing something, such as a code fragment, there must be another way to solve it.
11. The string written by the code fragment into cell 83 is Dim Irow As Integer, icol As Integer row Range("K7:V28).Row col Range( K7.V28).Column Range("B3").Value--(" & irow & ","&icol &")" 12. The string written by the code fragment into cell B4 is Dim nrows As Integer, ncols As Integer nrows Range("K7:V28") Rows.Count ncols . Range("K7:V28").Columns.Count RangeC B4") Value "("& nrows &""&ncols& 13. Make the two ranges refer to the same cell by filling in the blanks: Range("C5").Cells(33,17) Range("N12").Cells The cell absolute string address is 14. You can remove the $ from an absolute Address as follows: Range(Cells(3, 4), Cells(8, 12)).Address(False, False) The String address range is 15. Make the two ranges refer to the same cell. Range(D8").Offset( 3,5 ).Value 27 Range("D8"),Cells).Value 27 Both refer to cell: 16. Find the number of rows and columns for Range( Cells( 5, 12),Cells( 14,27)) Number of rows = , Number of columns ", Lower right: ; express both as strings. Upper leftStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started