+ Reply to Thread
Page 14 of 17 FirstFirst ... 4 12 13 14 15 16 ... LastLast
Results 196 to 210 of 243

How to post a range - headers and data?

  1. #196
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    I'll see what I can do when I have a moment, Sixth.
    Remember what the dormouse said
    Feed your head

  2. #197
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    OK, should be done now and I have updated the version on my site.

  3. #198
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India
    MS-Off Ver
    2003 To 2010
    Posts
    12,233

    Re: How to post a range - headers and data?

    Quote Originally Posted by romperstomper View Post
    OK, should be done now and I have updated the version on my site.
    Thanks for implementing the requested feature

    I will give a try and let you know


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #199
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    Just as an FYI, I have created a Mac-friendly version of the BB Code add-in. You can get it at the bottom of the page here: http://excelmatters.com/excel-forums/

  5. #200
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: How to post a range - headers and data?

    Quote Originally Posted by romperstomper View Post
    You're welcome, Ford.
    I have noticed with what I got from your post 181, that sometimes, it seems to remember the file it was last used in (if I have a few different files open), then when I try and use it again, it jumps back to that file, and wont accept the range from the current file. I end up having to close the file I used it previously in, and then it works fine again.

    Also, instead of actually showing colors, it shows their names instead (I think its only background colors, not font colors...
    B
    C
    D
    E
    F
    6
    [BGCOLOR=#FFFF00]1[/BGCOLOR]
    [BGCOLOR=#FFFF00]2[/BGCOLOR]
    [BGCOLOR=#FFFF00]3[/BGCOLOR]
    [BGCOLOR=#FFFF00]4[/BGCOLOR]
    [BGCOLOR=#FFFF00]5[/BGCOLOR]
    7
    [BGCOLOR=#FFFF00]102[/BGCOLOR]
    [BGCOLOR=#FFFF00]202[/BGCOLOR]
    [BGCOLOR=#FFFF00]302[/BGCOLOR]
    [BGCOLOR=#FFFF00]402[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    8
    [BGCOLOR=#FFFF00]104[/BGCOLOR]
    [BGCOLOR=#FFFF00]204[/BGCOLOR]
    [BGCOLOR=#FFFF00]304[/BGCOLOR]
    [BGCOLOR=#FFFF00]404[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    9
    [BGCOLOR=#FFFF00]106[/BGCOLOR]
    [BGCOLOR=#FFFF00]206[/BGCOLOR]
    [BGCOLOR=#FFFF00]306[/BGCOLOR]
    [BGCOLOR=#FFFF00]406[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    10
    [BGCOLOR=#FFFF00]108[/BGCOLOR]
    [BGCOLOR=#FFFF00]208[/BGCOLOR]
    [BGCOLOR=#FFFF00]308[/BGCOLOR]
    [BGCOLOR=#FFFF00]408[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    11
    [BGCOLOR=#FFFF00]114[/BGCOLOR]
    [BGCOLOR=#FFFF00]214[/BGCOLOR]
    [BGCOLOR=#FFFF00]314[/BGCOLOR]
    [BGCOLOR=#FFFF00]414[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    12
    [BGCOLOR=#FFFF00]116[/BGCOLOR]
    [BGCOLOR=#FFFF00]216[/BGCOLOR]
    [BGCOLOR=#FFFF00]316[/BGCOLOR]
    [BGCOLOR=#FFFF00]416[/BGCOLOR]
    [BGCOLOR=#FFFF00]#N/A[/BGCOLOR]
    13
    [BGCOLOR=#FFFF00][/BGCOLOR] [BGCOLOR=#FFFF00][/BGCOLOR] [BGCOLOR=#FFFF00][/BGCOLOR] [BGCOLOR=#FFFF00][/BGCOLOR] [BGCOLOR=#FFFF00][/BGCOLOR]


    Otherwise, this thing works great!!
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  6. #201
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    Hmm, looks like I needed more testing before trying to consolidate the HTML code with the BBCode version!

  7. #202
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: How to post a range - headers and data?

    haha. If its any help, Im running 8.1 (doesnt say what build), and Office 13 on I7 with 12 gig ram (not sure if this happens in office 10, but I can testy if needed)

    Its not a huge big deal, I just remove all colors before using. The "switch back to last copy area" can be a pain

  8. #203
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,726

    Re: How to post a range - headers and data?

    @ Ford

    I have noticed with what I got from your post 181, that sometimes, it seems to remember the file it was last used in (if I have a few different files open), then when I try and use it again, it jumps back to that file, and wont accept the range from the current file. I end up having to close the file I used it previously in, and then it works fine again.
    Me, too. I've discovered that if I go into the VBA editor and hit reset all is well.

  9. #204
    Registered User
    Join Date
    09-21-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: How to post a range - headers and data?

    Anybody here has an idea how will I can copy and paste the Alphanumeric beside the numbers column? When I copy and paste the alphanumeric it cannot be pasted because the area are not the same size and shape. I want the format of the numbers should be the same with the alphanumeric. Your help is greatly appreciated guys. Thank you so much.

    help.jpg

  10. #205
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,740

    Re: How to post a range - headers and data?

    josafe88

    Welcome to the forum. Pls take some minutes to read forum rules before you post again, because:

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  11. #206
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    @Ford,
    I've loaded an updated version. Can you download and retest? I think it fixes both issues. (there is no BBCode for cell fill, so it simply ignores that)

  12. #207
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: How to post a range - headers and data?

    Will do Rory. I am at work right now (W7/2007), so I will take a look when I get home - thats where it happens
    (now, all I have to do is find te post that has the upload LOL)

  13. #208
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: How to post a range - headers and data?

    Quote Originally Posted by FlameRetired View Post
    @ Ford

    Me, too. I've discovered that if I go into the VBA editor and hit reset all is well.
    Thanks I will try that. Was that just for the 'switch back" or for the color thing too?

  14. #209
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,301

    Re: How to post a range - headers and data?

    Quote Originally Posted by FDibbins View Post
    (now, all I have to do is find te post that has the upload LOL)
    You can download my current version from the link at the bottom of the page here: http://excelmatters.com/excel-forums/

  15. #210
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: How to post a range - headers and data?

    Thanks for the pointer, Rory. I found the link, will try it when I get home (I work 3-11)

+ Reply to Thread
Page 14 of 17 FirstFirst ... 4 12 13 14 15 16 ... LastLast

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