Help on describing how some codes works

Good Evening all


Would someone please take the time to look at the code below
and at the end of each line give me a brief description of just
what that line of code is saying or expected to do.

At this point I will not be putting up a sample file.

Please Login or Register  to view this content.

Many Thanks in advance for any help


Peter

Good evening


Thank you for that I will now have to work out if the code is doing the right thing for me.

As I have to change some of the cells info.


Many Thanks

Peter

Please Login or Register  to view this content.

Note: Is it clear enough ?

Alert => are values in RngArr referenced from 0 to 5 or from 1 to 6 ????

@ PCI

Please Login or Register  to view this content.

@Sintek
Thank you for the information.
The purpose of the comment was to point out the confusion which may exist ( refrencing array) and to pay enough attention on the reference.
Finally

Please Login or Register  to view this content.

Clean up any doubt
Thx again and happy new year, with Excel of course
PCI

Okay cool...Yes and same to you...Happy Coding...

Please keep everything related to this issue in one thread here: https://www.excelforum.com/excel-pro...e-altered.html

Thanks.