1 min readfrom 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

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#rows.com
#collaborative spreadsheet tools
#modern spreadsheet innovations
#self-service analytics tools
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#business intelligence tools
#google sheets
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet