Prev: pagesetup.printarea cannot getting infos from .xlsx file
Next: "fixed objects will move" warning
From: Isis on 5 May 2010 07:10
I am using this code to give me cell by cell access to a code defined
selection;

Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
Next aCell

which processes every cell in the A4:A34 Range

How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?

Thanks
From: Ron Rosenfeld on 5 May 2010 07:20
On 05 May 2010 11:10:21 GMT, Isis <isissoft(a)NOSPAMbtinternet.com> wrote:

>I am using this code to give me cell by cell access to a code defined
>selection;
>
>Dim aCell As Range
>For Each aCell In Sheet4.Range("A4:A34")
>' Do Stuff Here
>Next aCell
>
>which processes every cell in the A4:A34 Range
>
>How do I do the same thing for a selection drawn by the user before
>pressing my 'Process' button ?
>
>Thanks


Dim aCell As Range
For Each aCell In Selection
' Do Stuff Here
Next aCell
--ron
From: Isis on 5 May 2010 07:51
Ron Rosenfeld <ronrosenfeld(a)nospam.org> wrote in
news:a3l2u5tp1273ekqt29auf59cjdn3g56vk5(a)4ax.com:

> Dim aCell As Range
> For Each aCell In Selection
> ' Do Stuff Here
> Next aCell
>

Ron, thanks very much for that - worked great !

Regards
 | 
Pages: 1
Prev: pagesetup.printarea cannot getting infos from .xlsx file
Next: "fixed objects will move" warning