View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] youu917@gmail.com is offline
external usenet poster
 
Posts: 29
Default select the range with the cell's position is a variable.

can anyone tell me how to select a range which will keep changing? for
eg:
Sub select_range()
Dim abc As Range
Dim a As Integer
Dim b As Integer

a = 2 + 2
b = 2
abc = Range("ab")
abc.Select

End Sub

How to modify the code if i wish to make the a, b as a variable?