<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV>I want the user to define the range - this will vary. The only thing
that doesn't vary is the column range.</DIV>
<DIV> </DIV>
<DIV>Thanks for your input.<BR><BR>>>> paul.hartland@fsmail.net
03/21/03 10:10AM >>><BR>Terri,<BR><BR>Try something like this
:<BR><BR>Sub Macro1()<BR> Range("A10:R20").Select<BR>End
Sub<BR><BR>Paul<BR><BR><BR>From: "Terri Jarus"
<jarus@amerinet-gpo.com><BR>Date: Fri 21/Mar/2003 16:09 GMT<BR>To:
<accessd@databaseadvisors.com><BR>Subject: [AccessD] OT: Excel 97
Macro<BR><BR>Hope someone can give me some guidance or point me to some websites
to<BR>review.<BR><BR>I just need to write a simple macro that allows the user to
select a<BR>range of rows to sort. The column range is always going to be
the same.<BR><BR>For example, the user selects A10:A20 as the range of rows to
sort and<BR>the column range will always be through R.<BR><BR>Thanks for any
help. Let me know if more info is
required.<BR><BR>Thanks.<BR><BR><BR>__________________________________________________________________________<BR>Freeserve
AnyTime - Go online whenever you want for just £6.99 a month for<BR>your first 3
months, that's HALF PRICE! And then it's just £14.99 a month<BR>after
that.<BR><BR>For more information visit <A
href="http://www.freeserve.com/time/">http://www.freeserve.com/time/</A> or call
free on <BR>0800 970
8890<BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR>AccessD@databaseadvisors.com<BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></DIV></BODY></HTML>