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.....


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  How to assign values Dynamically to Range Statement - srinivas reddy  03-Jul-08 09:51 9:51:18 AM
      solution to assigning 2 vals - Umapathy Kaliaperumal  03-Jul-08 09:59 9:59:36 AM
          Reply - srinivas reddy  04-Jul-08 05:22 5:22:21 AM
      Try this - Jason S  03-Jul-08 10:00 10:00:08 AM
      range - sundar k  03-Jul-08 12:00 12:00:20 PM
      Try this - santhosh kumar  04-Jul-08 02:02 2:02:59 AM
View Posts