I have been using Range("MyRangeName").value for some time and now I saw a solution offered which instead just uses [MyRangeName] and leaves off Range and Value. How long has this been available? I could have saved considerable time. Thanks to HalfAce on Mechanic's problem. However, I couldn't get Me.Name to work. Does this work for others?