Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel: How to Access closed workbook Cell Value(s)?
I need some help on how to create an Excel function that will allow me to check for the value of a Dynamically determined NameRange (Day1, Day2.. etc...) on a CLOSED workbook/worksheet. I have found how to create such a function (via search engine(s)), but its only accessible via VBA calls, and...- KHMcKenna
- Thread
- Replies: 12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
=IF(GetClosedCellValue("C:\Path\[filename.xls]!Range") <> "
I very much need help, any input would be greatly appreciated. I need to be able to find out if an Excel user has entered a value into a particular cell/rangename. The cell/rangename will not be static, so I need to be able to dynamically query anywhere in the sheet (based on established range...- KHMcKenna
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
