Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel rows hidden when it is empty Excel rows hidden when it is empty
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2020, 11:16 PM
allex011 allex011 is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2007
Advanced Beginner
Excel rows hidden when it is empty 		 
Join Date: Dec 2017
Posts: 40
allex011 is on a distinguished road
Default Excel rows hidden when it is empty
I need help with one sheet who collect values from different workbooks.Is it possible that in that sheet to have hidden rows until they are filed with values from another workbooks?



Thank in andvanced
Attached Files
File Type: xls Sheet1.xls (28.0 KB, 9 views)
Last edited by allex011; 03-14-2020 at 03:06 AM.
Reply With Quote
  #2  
Old 03-14-2020, 06:07 AM
NoSparks NoSparks is offline Excel rows hidden when it is empty Windows 10 Excel rows hidden when it is empty Office 2010
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Perhaps like this
Attached Files
File Type: xls Sheet1.xls (33.5 KB, 12 views)
Reply With Quote
  #3  
Old 03-14-2020, 08:31 AM
allex011 allex011 is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2007
Advanced Beginner
Excel rows hidden when it is empty 		 
Join Date: Dec 2017
Posts: 40
allex011 is on a distinguished road
Default
Thank you, very much
Reply With Quote
  #4  
Old 03-16-2020, 06:54 PM
Marcia's Avatar
Marcia Marcia is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by NoSparks View Post
Perhaps like this
I tried this by pasting formulae in sheet 1 with another workbook as the reference. The macro did not hide the rows containing cells with formulae even if the result is zero.
Reply With Quote
  #5  
Old 03-16-2020, 09:33 PM
NoSparks NoSparks is offline Excel rows hidden when it is empty Windows 10 Excel rows hidden when it is empty Office 2010
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Cells with formulas are not empty and cells with formulas do not trigger the Worksheet_Change event.


If you're having issues with what you have start a new thread.
Reply With Quote
  #6  
Old 03-16-2020, 09:55 PM
Marcia's Avatar
Marcia Marcia is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Thank you, I will start a new thread then.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook kiwimtnbkr Excel Programming 4 06-26-2019 11:30 AM
Locate data from 3 columns in all of excel sheet habib90 Excel 3 04-18-2016 08:54 AM
Excel rows hidden when it is empty Excel vba to check to check if two columns are empty subspace3 Excel Programming 5 07-09-2015 04:45 PM
Excel rows hidden when it is empty Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
Excel rows hidden when it is empty Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft