Hiding Rows

Excel-ent · Mar 30th, 2004, 06:00 AM

Hi,

I have been told by the Experts that to hide the row containing zeros or blanks, I can filter and then the remaining cells can be copies to another sheet by Edit Copy –new sheet - Edit Paste special – visible cells only.

A macro for the above would be most appreciated.

If Zero or blank cell is found from G12 - G65536, then the those rows to be hidden. The visible cells only to be transferred to a new sheet.

I am using Windows 98 & Office 2000
Best Regards,

Shan

Mar 30th, 2004, 06:00 AM	#1
Excel-ent Join Date: Mar 2004 Location: Dubai Posts: 338	Hiding Rows Hi, I have been told by the Experts that to hide the row containing zeros or blanks, I can filter and then the remaining cells can be copies to another sheet by Edit Copy –new sheet - Edit Paste special – visible cells only. A macro for the above would be most appreciated. If Zero or blank cell is found from G12 - G65536, then the those rows to be hidden. The visible cells only to be transferred to a new sheet. I am using Windows 98 & Office 2000 Best Regards, Shan

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode