select a variable range

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: evil baby <evil.baby.24d7uy_1141845315.5551@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 8 Mar 2006 13:15:00 -0600

I want to select coloums A-BR of different rows in a loop.

How do I setup the Range (A[some_number]:BR[some_number]).select

the number will change a few times and wont be the same everytime I run
the macro

--
evil baby
------------------------------------------------------------------------
evil baby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31983
View this thread: http://www.excelforum.com/showthread.php?threadid=520237

.

Follow-Ups:
- Re: select a variable range
  - From: Tom Ogilvy
- Re: select a variable range
  - From: Justin Philips

Prev by Date: Re: EXCEL file corruption
Next by Date: Re: Pasting Dates from Clipboard of Web Page to Excel
Previous by thread: Closing Forms
Next by thread: Re: select a variable range
Index(es):
- Date
- Thread