[AccessD] OT: Excel 97 Macro

Terri Jarus jarus at amerinet-gpo.com
Fri Mar 21 10:27:00 CST 2003


I want the user to define the range - this will vary.  The only thing
that doesn't vary is the column range.

Thanks for your input.

>>> paul.hartland at fsmail.net 03/21/03 10:10AM >>>
Terri,

Try something like this :

Sub Macro1()
    Range("A10:R20").Select
End Sub

Paul


From: "Terri Jarus" <jarus at amerinet-gpo.com>
Date: Fri 21/Mar/2003 16:09 GMT
To: <accessd at databaseadvisors.com>
Subject: [AccessD] OT: Excel 97 Macro

Hope someone can give me some guidance or point me to some websites to
review.

I just need to write a simple macro that allows the user to select a
range of rows to sort.  The column range is always going to be the same.

For example, the user selects A10:A20 as the range of rows to sort and
the column range will always be through R.

Thanks for any help.  Let me know if more info is required.

Thanks.


__________________________________________________________________________
Freeserve AnyTime - Go online whenever you want for just £6.99 a month
for
your first 3 months, that's HALF PRICE! And then it's just £14.99 a
month
after that.

For more information visit http://www.freeserve.com/time/ or call free
on 
0800 970 8890


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030321/b87676a0/attachment-0001.html>


More information about the AccessD mailing list