Does God ever actually say No to our Prayers? Your immediate response to such a question is probably, “Yes, he often says No!” In which case, I encourage you to reflect on J. I. Packer’s answer.
“God’s yes is regularly a case of ‘your thinking about how I could best meet this need was right’; his no is a case of ‘not that, for this is better’ – and so is really a yes in disguise! – and his wait (which we infer from the fact that though we have asked for action, nothing yet has changed) is a case of ‘wait and see; I will deal with this need at the best time in the best way. Whether or not you will be able to discern my wisdom when I do act, that is what in fact I am going to do. Keep watching, and see what you can see” ("Praying," pgs 173-74).
“We have it on firm scriptural authority that the Father’s response to requests faithfully, humbly, hopefully, expectantly made by his own children, out of a pure heart and an honest desire for God’s glory, is never going to be a flat no. One way or another God’s response will be a positive response, though it may be ‘I am adjusting the terms of your prayer to give you something better than you asked for.’ Or it may be, ‘I know that this isn’t the moment in which answering your prayer would bring you and others most blessing, so I’m asking you to wait.’ Or it may be, ‘I am answering your prayer, but you don’t know the strategy I’m working on, and it doesn’t at the moment feel or look like an answer at all. Nonetheless, it is. Keep praying, keep trusting, and keep looking for what, down the road, I may be able in wisdom to let you see” (pg 177).