Thread: [Solved] How to hide rows that have no data but has formula in cells?
View Single Post
 
Old 02-13-2018, 06:31 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
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
Glad you figured out your error.

You might want to check things out a little further though.
Quote:
Columns: A to M
Rows: A4-A503
cl.Offset(,13) will be column N

PS: please update your profile to reflect the version of Excel you use, thanks.
Reply With Quote