How to assign values Dynamically to Range Statement |
| srinivas reddy posted at 03-Jul-08 09:51 |
Usally if we want to select the data from A10 cell to D13 cell we will write the statement as
Range("A10:D13").select
here i want to assign the values(10,13) dynamically.means using some variables i and j.
Range("A13:D" & i)--this is the statement to assign only one value.
I want to assign 2 values using some other variables.
Can anyone help me please..... |
|