#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Scores returning ranked results | TerryStevenson | Excel | 1 | 09-16-2013 12:20 PM |