How can I use office script to find the value of a specific cell, and if it is empty, hide a range of rows in Excel?

Skyler Nichols 0 Reputation points
2024-01-11T03:17:08.3066667+00:00

Hello,

I'm just beginning with Office Script and am trying to automate a tedious process at work. I need to do the following:

  1. Find the value of C14
  2. If C14 is empty, hide rows 14-25
  3. Find the value of C28
  4. If C28 is empty, hide rows 28-39
  5. repeat

I've tried to utilize several scripts that I've found online, but haven't been able to get any to work the way that I need.

Thank you!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,144 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,228 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.