All I remember of its is a single line:
“…nae mair we’ll go a roving, by the light of the moon”
I’m really trying to find the poem…can’t get it out of my head, so there must be something of importance to me (albeit subconsciously)! 
You sure it’s Burns and not Lord Byron?
It also lends its name to a Ray Bradbury “Martian Chronicles” story, “And the Moon Be Still as Bright.”