Hi,
I've a rows and columns filled up like below.
col1 col2 col3 col4 col5 col6 col7
-------------------------------------------
Row1- c11 c12 c13 c14 c15 c16
Row2- c21 c22 c23 c24 c25 c26
Row3- c31 c32 c33 c34 c35 c36
Row4- c41 c42 c43 c44 c45 c46
Row5- c51 c52 c53 c54 c55 c56
Row6- - - - - - -
Row7- c71 c72 c73 c74 c75 c76 c77 c78
Row8- c81 c82 c83 c84 c85 c86 c87 c88
Row9- c91 c92 c93 c94 c95 c96 c97 c98
How should I know that last used column is col7 for rows (1 to 5)?
Same Qns for Rows (7 to 9)?
After that I want to select the used range (excluding col1) for both of teh ranges.
Thx.
I've a rows and columns filled up like below.
col1 col2 col3 col4 col5 col6 col7
-------------------------------------------
Row1- c11 c12 c13 c14 c15 c16
Row2- c21 c22 c23 c24 c25 c26
Row3- c31 c32 c33 c34 c35 c36
Row4- c41 c42 c43 c44 c45 c46
Row5- c51 c52 c53 c54 c55 c56
Row6- - - - - - -
Row7- c71 c72 c73 c74 c75 c76 c77 c78
Row8- c81 c82 c83 c84 c85 c86 c87 c88
Row9- c91 c92 c93 c94 c95 c96 c97 c98
How should I know that last used column is col7 for rows (1 to 5)?
Same Qns for Rows (7 to 9)?
After that I want to select the used range (excluding col1) for both of teh ranges.
Thx.