Suppose I have the following range object defined:
Suppose test_range maps to the range A1:A10 (i.e. test_row_start = 1, test_col = 1, test_row_end = 10). How can I display "A1:A10" in a popup box for debug purposes?
I have already tried this:
but receive a "type mismatch" error.
The following also generates a "type mismatch" error:
Code:
Set test_range = Range(Cells(test_row_start, test_col), Cells(test_row_end, test_col))
Suppose test_range maps to the range A1:A10 (i.e. test_row_start = 1, test_col = 1, test_row_end = 10). How can I display "A1:A10" in a popup box for debug purposes?
I have already tried this:
Code:
MsgBox "test_range = " & test_range
but receive a "type mismatch" error.
The following also generates a "type mismatch" error:
Code:
MsgBox "test_range = " & CStr(test_range)