Sayyiduna Abbas bin Abdul Muttalib (may Allah be pleased with him) said: I saw in a dream that a sun or a moon was being lifted from the earth and taken to the sky. He related this dream to the Prophet Muhammad (peace and blessings be upon him), so he (peace be upon him) interpreted it that it referred to the death of his nephew, meaning the Messenger of Allah (peace and blessings be upon him) himself.
Hadith Takhrijاس حدیث کی سند صحیح ہے۔ دیکھئے: [كشف الاستار للبزار 844] و [مجمع الزوائد 23/9-24]
Brief Explanation
(Commentary on Hadith 2193)
That is, you (sallallahu alayhi wa sallam) will pass away.
From this it is understood that the Messenger of Allah (sallallahu alayhi wa sallam) neither disappeared from the world nor was he raised up to the heavens, rather, like other prophets, he (sallallahu alayhi wa sallam) also passed away.
From this it is understood that ascending towards the heavens or someone being taken up is an indication towards his death.