+ Reply to Thread
Results 1 to 3 of 3

Add the titles to the columns, after Range().clear

Hybrid View

sacoo Add the titles to the... 02-12-2005, 02:25 PM
jindon Hi try Sub titl() Dim... 02-12-2005, 08:32 PM
sacoo Thank you 02-12-2005, 08:49 PM
  1. #1
    Registered User
    Join Date
    02-10-2005
    Posts
    3

    Add the titles to the columns, after Range().clear

    Is there anyway, to copy a range of values (that are not in any cell) to a range of cells?
    I need that {A1,B1,C1,D1} have the values {Time, Traffic, Operation, BW}
    i know I can make it individually, but I would prefer to make all in a row.

    The problem is that I clean the cells using Range(A:D).clean, and that also cleans the titles, maybe theres' another approach??


    Thanks so much

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834
    Hi
    try
    Sub titl()
    Dim titl
        titl = Array("Time", "Traffic", "Operation", "BW")
        Range("a1").Resize(1, UBound(titl) + 1).Value = titl
    End Sub
    rgds,
    jindon

  3. #3
    Registered User
    Join Date
    02-10-2005
    Posts
    3

    Thank you

    Thanks a lot, I really needed that and there was no way to find it!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1