How to change columns Titles
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to change columns Titles

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm a Newbie in VB and I have some difficulties to make a simple macro (I think).
    My macro should change the titles ( in A->" Date" , B->"Salary", .... )of the columns ( or rows ) in order to screen them even if i'm editing the thousandths row ( or column ).
    Thank you for your help.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So are you saying that you want VB code that will fill in or change your column headings?

    Or are you trying to get VB code to *capture* the column headings that are already there.

    I'm sorry, it's not clear to me exactly what you are after. If you have some code that doesn't work quite right for you, please paste it for the coders to see.

    Thanks!
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I was thinking to use VB to change the *Headings* of the columns but by seeing your answer it seems to have a simpliest solution...
    Sorry but as I was telling in my first topic I'm a newbie in VB. I would have had to specify : in excel too !



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com