Consulting

Results 1 to 6 of 6

Thread: random columns to be copied

  1. #1

    random columns to be copied

    hi

    i have 25 columsns in my excel.
    In my first row i have Months and each month is Merged for 5 columns
    in my second column i have date, average time, etc
    i have to select average time from each month thru a macro

    but if i try to select one column suppose "B:B" , excel is selecting all the five columns from that particular month like "A:E" because my first row is merged

    Please help me

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Edit: Response deleted because OP is cross-posting at MrExcel, and I forgot it was him when I responded.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    i am new to this forum, and i dont know that both vbaexpress and Mrexcel
    are same.........
    please guide me if i am wrong.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    What you are doing is putting your needs above the needs of the responders by getting more than one person working on your problem. It may be the most important thing to you, but it is not for us, and we offer free help as a goodwill gesture. Actions like yours break the goodwill.

    VBAExpress and MrExcel are not the same, but some people visit both, and that is how cross-posting may be spotted. But others don't, and they may continue looking for a solution on one board when it has already been resolved on another, as happened yesterday with your post.

    It is generally considered at least mitigation if you mention that you cross-posted on another board, with a link, people will at least know; like myself, they can then not bother even trying to help if they so choose.
    Last edited by Bob Phillips; 08-28-2008 at 02:39 AM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    thankyou so much for making me understand,
    in future i will not do this kind of mistake
    i will post in any one forum or atleast i will put the link as u told

  6. #6
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,059
    Location
    This thread is now closed. k_v_deepu, if you believe that there is merit is reopening this thread, you may request someone from Admin to do so, however given that you were offered a solution at another forum, it would need to be a significant reason to do so.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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