How to insert border around text in footer dynamically in excel?


D

divya nila

Hi,

I want to add a border around text in footer of excel after insertin
the text in footer dynamically using VBA macro. In my excel i have adde
left side footer and right side footer as images and added some text i
middle footer. I am adding this text in middle footer using VBA macr
and i need to add border around this text like the left side footer an
right side footer.

I have attached the image of the excel. Please see and give solution.

Thanks in Advance

+-------------------------------------------------------------------
|Filename: sample_excel.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=899
+-------------------------------------------------------------------
 
Ad

Advertisements

K

khosla12

divya said:
Hi,

I want to add a border around text in footer of excel after insertin
the text in footer dynamically using VBA macro. In my excel i have adde
left side footer and right side footer as images and added some text i
middle footer. I am adding this text in middle footer using VBA macr
and i need to add border around this text like the left side footer an
right side footer.

I have attached the image of the excel. Please see and give solution.

Thanks in Advance.


please refer the file attached. the file is untidy. i need to look u
values based on multiple conditions and insert simple calculation
within look up formula

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top