CalRich1023
New Member
- Joined
- Mar 15, 2021
- Messages
- 48
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
I was wondering if there is a way to create a macro (assigned to a button-I can do this part) to print all occupied cells on a sheet? I have a search page that will produce varying rows of results, and I was hoping for a quick way to just print the cells that have contents.
If it helps, I can define the width of the area from cells A1:K1, but the bottom (last row) of the data will vary depending on the search results.
Thanks
I was wondering if there is a way to create a macro (assigned to a button-I can do this part) to print all occupied cells on a sheet? I have a search page that will produce varying rows of results, and I was hoping for a quick way to just print the cells that have contents.
If it helps, I can define the width of the area from cells A1:K1, but the bottom (last row) of the data will vary depending on the search results.
Thanks