Hi Prince,
Thanks a lot for your reply.
To add, number of pages vary in every sheet. I have just given an example.
Is it possible that every last page in the sheet (irrespective) of the
pages has a different footer.
Thanks in advance.
On Wednesday, January 22, 2014 7:34:45 AM UTC+5:30, Naresh
Hi Prince,
Thanks a lot for your reply.
To add, number of pages vary in every sheet. I have just given an example.
Is it possible that every last page in the sheet (irrespective) of the
pages has a different footer.
Thanks in advance.
On Wed, Jan 22, 2014 at 11:51 AM, Prince wrote:
>
> I hope
I hope this may help you.
Sub PrintSheet()
dim lngCtras Long
dim wks as worksheet
lngctr=0
for each wks in thisworkbook.worksheets
lngctr=lngctr+1
With wks.PageSetup
.LeftFooter = "Left Footer Text"
if lngctr=20 then
.Cent
