First off, I am pretty new to VBA (only really used VBS so far) and have come
across a lot of terms like xlValue, xlUp, xlDown etc. but I cannot find any
reference that explains what they actually do.

Any help gratefully appreciated.