Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2018, 01:03 PM
jennyyoung jennyyoung is offline Indirect results returning 0 instead of blank Windows 7 32bit Indirect results returning 0 instead of blank Office 2010 32bit
Novice
Indirect results returning 0 instead of blank
 
Join Date: Apr 2018
Posts: 15
jennyyoung is on a distinguished road
Default Indirect results returning 0 instead of blank

I am using an indirect formula and I need blank cells to remain blank instead of 0.



this i the formula
='\\177.177.1.14\Sales\Order Status 2018\[Jason''s Orders.xlsx]Jasons Customers'!A79
Reply With Quote
  #2  
Old 04-30-2018, 07:25 PM
BobBridges's Avatar
BobBridges BobBridges is offline Indirect results returning 0 instead of blank Windows 7 64bit Indirect results returning 0 instead of blank Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

There's some mistake here — two mistakes, in fact, I believe. First, if you're writing a VBA program (and this is after all the Excel Programming forum), what code are you using to generate that formula? Because we'd want to confirm, to start, that it is in fact generating that address rather than some other. And second, that isn't an indirect address. Or at least, when you said you're using an "indirect formula" I assumed you meant you're using the INDIRECT function to generate an address, and there's no INDIRECT function there.

Maybe you should try describing your problem again. If you're not writing a VBA program, describe it in the other forum, the one labeled merely "Excel". And if you're not sure what you mean by an "indirect formula", feel free to ask questions; maybe we can straighten this out with a little further discussion.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indirect results returning 0 instead of blank COUNTIFS function is only returning partial results rgauss Excel 2 01-25-2017 01:26 PM
Filter not returning all relevant results hnhorner Excel 3 07-12-2015 05:33 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N mikey386 Excel 2 12-11-2014 01:14 PM
2013 search results take a long time - they fill in as results in reverse date order themookman Outlook 0 10-11-2013 12:01 PM
Indirect results returning 0 instead of blank Scores returning ranked results TerryStevenson Excel 1 09-16-2013 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:00 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