Identifying & Selecting an Unknown Range?
Assume data entered from B4 (known point) to unknown Column (Y). Data will
be entered in many rows. Also assume that Col B is used to establish last
row used and that last row returns as (X). Would like to find and select
Range(B4:YX).
Have found and tried a couple of codes doing a search in the forumn that
seemed to address this but have not been able to get any of them tweaked.
I'm using 2003, if that matters. Hope this is clear enough. Thanks for any
help here.
|