the macro recorder, ie: CurrentRegion
>
> Regards - Dave.
>
> > Date: Fri, 20 Aug 2010 13:04:43 -0700
> > Subject: $$Excel-Macros$$ Naming ranges which change in size using VBA
> > From: davidmstu...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hello
it.
We can bundle .End(xlDown)'s (and more) together on a single line.
We can use things not available to the macro recorder, ie: CurrentRegion
Regards - Dave.
> Date: Fri, 20 Aug 2010 13:04:43 -0700
> Subject: $$Excel-Macros$$ Naming ranges which change in size using
Hello everyone,
I am trying to write a macro to name four ranges in a sheet. The
ranges will have the same width every time, and the ranges below the
two at the top with always be separated by 1 blank row but more or
less rows. I thought it would work by using:
Range(Selection, Selection.End(xlDo