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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

=IF(GetClosedCellValue("C:\Path\[filename.xls]!Range") <> "

Status
Not open for further replies.
KHMcKenna

KHMcKenna

Technical User
Nov 30, 2001
9
US
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 naming).

I have found a "GetValue" function, it works, BUT it can't be called from a sheet formula as it needs to be.
 
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
373
kapok1
kapok1
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
518
SkipVought
S
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
372
mintjulep
M
NewbieMacro
  • Locked
  • Question
Hello, I have a sheet named "Fin
Replies
2
Views
138
NewbieMacro
NewbieMacro
MattGreer
  • Locked
  • Question
Using A Boolean in a Calc, and setting a variable = "0" 3
Replies
6
Views
175
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top