Using selections in VBA
I'd like to thank both of you for helping me. Yes, what you suggest would do
what I request but my example badly stated what I was really after. What I
would like to know is, how would VBA know how many non-contiguous sections
were contained in the selection, and for each section, what are the top and
bottom rows and the left and right columns? Perhaps this question would have
been presented better if I had asked to have each cell in the selection have
the following information put into it ... "This cell in in row " & Row_ & "
and column " & Col_ & " of section number " & section & "."
My question is, how would I set up my loops to have the correct values of
Row_, Col_, and Section_ ?
Thank you
|