My current code works fine as presently designed but will like to modify it further such that the ROW HEIGHTS for will alway remain as designed when code creates the excel file to be saved to a folder.
My template "Name.xlt" is designed as follows:
(a) Row 1 is a Company Name Title heading has a row height of 20 inches from columns 1 through 7
(b), Row 2 through 4 are other Title row headings with row height of 18 inches from columns 1 through 7
(c). Row 5 also is the last title heading and it has a row height of 36 inches from columns 1 through 7
(d). Row 6 through 39 (are the data rows) has row height of 18 inches from columns 1 through 7
As such I will like to:
(1). create variables / code for item (a) above such that the row height for item (a)will always
maintain a row height of 20 inches for all the pages of excel data file that the code will create.
(2). create variables / code for item (b) and (d) above such that the row height for item (b) and (d)
will always maintain a row height of 18 inches for all the pages of excel data file that the
code will create
(3). create variables / code for item (c) above such that the row height will always maintain a
row height of 36 inches for all the pages of excel data file that the code will create.
(4). And lastly, assumming that the margin for my template "Name.xlt" are set as follows:
Left=0.75; Right = 0.5; Top = 0.5; and Bottom = 0.5.
Is it possible to utilize code to maintain the same margin set for the excel file the code would create such that data created in the excel file will maintain the exact format of the template - made possible by the defined margins?
I am not sure this possible, I am just trying to experiment.
My curent code is hereby attached.
Start Free Trial
