R
robboll
Given (A 10 X 10 Grid) as follows:
---A--B--C--D--E--F--G--H--I--J
1|ab-ac-ad-ae-af-ag-ah-ai-aj-ak
2|al-am-an-ao-ap-aq-ar-as-at-au
3|av-aw-ax-ay-az-ba-bb-bc-bd-be
4|bf-bg-bh-bi-bj-bk-bl-bm-bn-bo
5|bp-bq-br-bs-bt-bu-bv-bw-bx-by
6|bz-ca-cb-cc-cd-ce-cf-cg-ch-ci
7|cj-ck-cl-cm-cn-co-cp-cq-cr-cs
8|ct-cu-cv-cw-cx-cy-cz-da-db-dc
9|dd-de-df-dg-dh-di-dj-dk-dl-dm
0|dn-do-dp-dq-dr-ds-dt-du-dv-dw
I am looking for a function that, when you select a specific grid
(e.g., cd), it displays the entirety of the grid values in a spiral
pattern around the starting grid as follows:
cd
bt
bu
ce
co
cn
cm
cc
bs
bi
bj
bk
bl
bv
cf
..
..
..
The function should also account for the edge of the grid. For
example, if you select (e.g., by) it should display the results:
by
bo
ci
ch
bx
bn
bd
be
cs
cr
cq
cg
bw
bm
bc
as
at
au
oc
..
..
..
Does anyone have an idea of how to go about this using VBA?
Thanks for any assistance.
RBollinger
---A--B--C--D--E--F--G--H--I--J
1|ab-ac-ad-ae-af-ag-ah-ai-aj-ak
2|al-am-an-ao-ap-aq-ar-as-at-au
3|av-aw-ax-ay-az-ba-bb-bc-bd-be
4|bf-bg-bh-bi-bj-bk-bl-bm-bn-bo
5|bp-bq-br-bs-bt-bu-bv-bw-bx-by
6|bz-ca-cb-cc-cd-ce-cf-cg-ch-ci
7|cj-ck-cl-cm-cn-co-cp-cq-cr-cs
8|ct-cu-cv-cw-cx-cy-cz-da-db-dc
9|dd-de-df-dg-dh-di-dj-dk-dl-dm
0|dn-do-dp-dq-dr-ds-dt-du-dv-dw
I am looking for a function that, when you select a specific grid
(e.g., cd), it displays the entirety of the grid values in a spiral
pattern around the starting grid as follows:
cd
bt
bu
ce
co
cn
cm
cc
bs
bi
bj
bk
bl
bv
cf
..
..
..
The function should also account for the edge of the grid. For
example, if you select (e.g., by) it should display the results:
by
bo
ci
ch
bx
bn
bd
be
cs
cr
cq
cg
bw
bm
bc
as
at
au
oc
..
..
..
Does anyone have an idea of how to go about this using VBA?
Thanks for any assistance.
RBollinger