We are all familiar with the statement:
Range(A1:B4).select
But what if you do not have "A1" or "B4" but numbers eg
Top left co-ordinate=1,1 and the bottom right co-ordinate=
2,4 (you get these from activecell.row or activecell.column syntax when you are navigating around the range#
How do I select a range with row & column numbers only?
Many thanks
Range(A1:B4).select
But what if you do not have "A1" or "B4" but numbers eg
Top left co-ordinate=1,1 and the bottom right co-ordinate=
2,4 (you get these from activecell.row or activecell.column syntax when you are navigating around the range#
How do I select a range with row & column numbers only?
Many thanks