What does this line of code mean? Variable Date/Opening Files

[swade730]

Please Login or Register  to view this content.

Should I name the range of the cell in the workbook that holds the As of Date to "AsofDate" for this to work?

Ultimately i'm looking to open a file and I want to have a variable date in the file name.

[stnkynts]

"AsofDate" in Range("AsofDate") is referring to a named range within the worksheet. A named range could be 1 or multiple cells of data. AsofDate as a variable will return the date in format "MMM-DD" of Range("AsofDate") if the named range is 1 cell. It will error if "AsofDate" is multiple cells.

[swade730]

"AsofDate" in Range("AsofDate") is referring to a named range within the worksheet. A named range could be 1 or multiple cells of data. AsofDate as a variable will return the date in format "MMM-DD" of Range("AsofDate") if the named range is 1 cell. It will error if "AsofDate" is multiple cells.

Thank You, and is this regardless of what worksheet I designate the "AsofDate" on?

[stnkynts]

A named range is either worksheet specific or cannot be duplicated. I am not sure if this information answers your question