Help Understanding Some Code

Originally Posted by Richard Buttrey

Used Range.Offset(1) is commented out. UsedRange operates on whichever sheet is active

Hi Richard,

as you can see in the original thread (link in Sintek's post …)
this VBA procedure must be located in a specific worksheet module
so any range without any worksheet reference refers to this specific worksheet like UsedRange
whatever the active sheet !