Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2018, 12:48 PM
hop46 hop46 is offline Excel - open workbook - function - value = 0 Windows 7 64bit Excel - open workbook - function - value = 0 Office 2007
Novice
Excel - open workbook - function - value = 0
 
Join Date: Oct 2018
Posts: 1
hop46 is on a distinguished road
Default Excel - open workbook - function - value = 0

I have problem with my function.
I have function for selection (cell) from different sheets.
This funcion I use in several sheets.

My problem is with calculation for everything sheets
Because function counts only ones sheet..
Other sheets is showing in cell 0.
(Note after open workbook)



Workbook must recalculation everything sheets after I see value for cell.

Wher si problem?

How to modify the function?
if..
Do not have to recalculate the workbook when you open it?

Thank you for answer.

Function - save in module

Function ID_NAMES(ID)

ID_NAME = "!!!ERROR!!!"
If ActiveSheet.Name = ActiveSheet.Name Then

For ReqRow = 2 To 1000
CellOrder = CStr(ReqRow)
SelectSellFromWorkbook = "B" & CellOrder
If "Block function requirements" = Range(SelectSellFromWorkbook) Then
Exit For
End If
Next ReqRow


For CellOrderCnt = 2 To ReqRow

CellOrder = CStr(CellOrderCnt)
SelectSellFromWorkbook = "B" & CellOrder
If Sheets("ATG").Range(SelectSellFromWorkbook) = ID Then
SignalName = "C" & CellOrder
ID_NAME = Sheets("ATG").Range(NAME)
Exit For

End If

Next CellOrderCnt

End If

End Function
Reply With Quote
  #2  
Old 10-23-2018, 02:34 AM
p45cal's Avatar
p45cal p45cal is offline Excel - open workbook - function - value = 0 Windows 10 Excel - open workbook - function - value = 0 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Wouldn't a simple formula like:
=VLOOKUP(C5,ATG!$B$2:$C$1000,2,FALSE)
do it, where C5 is the cell containing the ID?


Or if you wanted the same error message:
=IFERROR(VLOOKUP(C5,ATG!$B$2:$C$35,2,FALSE),"!!!ERROR!!!")
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink function only fully works when referring workbook is open batchmaster Excel 1 01-26-2018 12:27 PM
Open Excel from MS Access and Password Protect Workbook bconner Excel Programming 2 09-21-2017 02:32 AM
How to add attached excel workbook with hyperlink in the same workbook lynchbro Excel Programming 0 02-24-2015 01:29 PM
Excel - open workbook - function - value = 0 Need to open an Excel WorkBook from Word VBA Pierre-Hugues Word VBA 4 10-07-2013 06:27 AM
Unable to open Excel 97-2003 workbook J Partridge Excel 1 11-07-2010 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft