[dba-Tech] Assign current selection to Range object

Hi Susan

Not sure but does the Selection property help? As in Application.Selection
which, according to Help, returns you a Range object if that's what's
selected.


--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Discussion of Hardware and Software issues"
<dba-tech at databaseadvisors.com>
To: "DBA Tech List" <dba-tech at databaseadvisors.com>
Subject: [dba-Tech] Assign current selection to Range object
Date: 18/03/08 16:30


I've run into this before and had trouble -- what is the simplest way to
define a Range object using the current range selection in a sheet?

For instance, if I select cells A1:B4, I want VBA to create a Range object
that equals A1:B4.

This shouldn't totally stump me, but I just can't get it and can't find
anything in Help -- thought I was on the right track with CurrentRegion, but
couldn't get it right.

Susan H.
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2