Noidea1970
New Member
- Joined
- Mar 5, 2020
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
I have a workbook that I have automated, using 2 buttons to add information and 1 button to delete the information and all tabs that get added.
(The 1st button is a search for and add gather the files I need, the 2nd button actually adds the information from each file).
To make it easier to read all the information I formatted the workbook with alternating shaded rows.
Using the following method. I went to format as a table, choose my color and size. Then choose all the rows and columns I needed.
Checked "my table has headers", Clicked OK
Than I went to convert to range and ended up with what I wanted, see image 1.
When I add the information the shaded rows go back to all white, see image 2.
Image 3 is the code to add the information to Excel. I have 4 workbooks that I use for 12, 25, 37 and 57 parts.
How can I stop it from going back to all white when the I formation is added?
(The 1st button is a search for and add gather the files I need, the 2nd button actually adds the information from each file).
To make it easier to read all the information I formatted the workbook with alternating shaded rows.
Using the following method. I went to format as a table, choose my color and size. Then choose all the rows and columns I needed.
Checked "my table has headers", Clicked OK
Than I went to convert to range and ended up with what I wanted, see image 1.
When I add the information the shaded rows go back to all white, see image 2.
Image 3 is the code to add the information to Excel. I have 4 workbooks that I use for 12, 25, 37 and 57 parts.
How can I stop it from going back to all white when the I formation is added?