shekhar_pc
Board Regular
- Joined
- Jan 29, 2006
- Messages
- 185
Code:
Sub Example1()
Dim r as Range
set r = range("A1:T65536")
Msgbox r.rows.count
End Sub()
Code:
Sub Example2()
Dim r as Range
set r = range("V1:AO34464")
Msgbox r.rows.count
End Sub()
I want to set a range that should carry 100000 rows. In short, I want to set data in the range V1:AO34464 exactly below A1:T65536 so that the total rows becomes 100000.
Is this possible? If yes, How?