March 29, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need a VBA Macro to change the height of empty rows

Our take

If you're managing a spreadsheet of comic book issues organized with empty rows for easy reference, a VBA macro can streamline your workflow. This macro will allow you to specify tables across different sheets, check the "Series" column for empty cells, and automatically set the height of those rows to 5px. This solution not only enhances the visual clarity of your document but also ensures that your formatting remains consistent. If you need additional details or clarification, feel free to ask for further information.

I have a spreadsheet that contains a list of comic book issues in a set reading order. Chunks of these issues are separated with an empty row so that I can, at a glance, know where I can insert new entries.

I'm hoping somebody can write me a macro that will accomplish the following:

- Allow me to name specific tables in my document across different sheets that I want the formatting to apply to

- check the "Series" column in any of those tables for empty cells

- set the row height for those cells to 5px

I used to have AI put together these kinds of things for me for the sake of speed but I have since stopped due to ethical concerns about the companies that control these tools. Please let me know if there is any information you need that I have left out by mistake.

submitted by /u/Ultinuc
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]

Tagged with

#rows.com

Need a VBA Macro to change the height of empty rows

Related Articles

Tagged with