Hi
I am new to VBA and I have the following problem:
I want to have different sections in a file and would like to start each section on a seperate page. I do not want to use a manual pagebreak since part of the page appears empty.
I would therefore like to insert blank rows untill the following section starts just after an automatic pagebreak. My code is as follows:
I have been facing the following problems:
T1 is able to be found, but T2 is giving the "Object does not support this property method".
I also tried with it with the following alternative
but it is giving me an error on the second iteration.
Any suggestions is welcomed.
A sample file is also attached.
Niraj
Bookmarks