I'm creating a macro, and need to select the first blank cell in a row.
My code now reads:
This selects the last cell with data, but I want to select the blank cell to the right. How would I write the code? Any help would be great.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!