range

sundar k replied to srinivas reddy at 03-Jul-08 12:00

I hope you want to do this in excel vba code, if its so then its pretty straightforward,

Sub test()
Dim rng As Range
Dim i As Integer
Dim j As Integer
i = 10
j = 13
Set rng = Sheet1.Range("A" & i & ":C" & j)
rng.Select
End Sub


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