Sometimes the Answer Is “No”
Doctrine and Covenants 9:9
9 But if it be not right you shall have no such feelings, but you shall have a stupor of thought that shall cause you to forget the thing which is wrong; therefore, you cannot write that which is sacred save it be given you from me.
President James E. Faust said:
“Of all that we might do to find solace, prayer is perhaps the most comforting. We are instructed to pray to the Father, in the name of His Son, the Lord Jesus Christ, and by the power of the Holy Ghost. The very act of praying to God is satisfying to the soul, even though God, in His wisdom, may not give what we ask for. President Harold B. Lee taught us that all of our prayers are answered, but sometimes the Lord says no.”
(“He Healeth the Broken in Heart,” Ensign, July 2005, 6–7.)