Re: $$Excel-Macros$$ cells shifting up!

Dear Muneer, Please follow below step and see attached Sample sheet. Select A1:D4 Range Press ctrl+G->goto Special-Check Blank Press ctrl- and Shieft Cell Up -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogs

$$Excel-Macros$$ cells shifting up!

Dear Friends, I need to shift the cells up to bring them in one single line. TR1 1 2 3 TR1 1 2 3 this is my target... Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED f