[dba-Tech] Excel question: go to a named range?

I am in no position to call myself expert at Excel VBA. But it turns out
that extensive experience in Access VBA pays off. I've just done some code
that opens numerous workbooks and grabs numbers from them to populate a
newly-created workbook, and it wasn't difficult at all.

GoTo doesn't handle an offset, but it does place you in the first cell of
the specified range, from which you can use OffSet with impunity, it
appears. I'm just discovering what is possible doing this, but I'm having
fun!

To answer your precise question, GoTo appears to take me to the place of
interest, and once that's established, then OffSet works nicely. Perhaps
there is a better way to do it, but for the moment this works.

On 8/19/07, Susan Harkins <ssharkins at gmail.com> wrote:
>
> GoTo handles an offset?
>
> Susan H.
>
> It's called GoTo. Whoever woulda thunk it? Doh!
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>