Customise Header

  • Thread starter Thread starter Amol
  • Start date Start date
A

Amol

I have data in text file which i want to convert on xl with selected
column (there is some unwanted column which i want to delete)
and want to change the header name of column with specific color and
and font type
can anyone suggest macro for that which can do the same and chang the
font type of all data
 
You can record a Macro that does this. From the menu choose Tools, Macros,
Record new macro. Then do all the formatting you want and click the square
stop button when you are done. Then you will have your macro.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
 
You must log in or register to reply here.

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Convert text into number code 0
convert columns to rows 6
Delete Rows as per Text, Font Color, Font Type, Time Format 11
Find Specific Rows in Range and Create New Tab 18
Conditional formatting with vba 3
Would love to write macro to delete any row that DOESN'T containspecific text.. 6
VBA CreateNames (ignores last 5 rows?) 6

Back
Top