Search for 'Shortcut Range References' on this WebPage.

http://msdn.microsoft.com/library/de..._chap05idx.asp

"This shortcut is convenient when you want to refer to an absolute
range. However, it is not as flexible as the Range property as it
cannot handle variable input as strings or object references."

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
What do you mean when you say that [A1] is a 'hardcoded range' and
range("A1").value isn't?