Thread: Ranges / Loops
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Brian B[_3_] Brian B[_3_] is offline
external usenet poster
 
Posts: 3
Default Ranges / Loops

Sorry, your suggested code is way out.
There are various ways of doing the job, bearing in mind that the
Range() argument is usually a *String*.

When using numbers, this is probably the best :-
i = 1
Range(Cells(1, 1 + 1), Cells(2, 1 + i)).Select


Regards
BrianB
----------------------------------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!