Note the change in the code in the prior post:

sName = wks.Parent.Name