+ Reply to Thread
Page 15 of 17 FirstFirst ... 5 13 14 15 16 17 LastLast
Results 211 to 225 of 243

How to post a range - headers and data?

  1. #211
    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?

    Romper, I have tried that link again, but it doesnt seem to be working?
    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

  2. #212
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Win 2010-2016
    Posts
    11,121

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

    I think Rory has had it with this forum.

    I can't quite tell what link you are referring to, but the link in Rory's post #209 takes me to his blog just fine. On that page scroll to the end of his text and find the link to the tool.

    For convenience's sake, here it is again:

    https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0

    cheers, teylyn

  3. #213
    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?

    teylyn, thanks for that. I could get to his site
    http://excelmatters.com/excel-forums/
    but the link to the file (marked "here") did not work - but when I just checked again now, it does

    Again, thank you

  4. #214
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Win 2010-2016
    Posts
    11,121

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

    You're welcome. It's great tool and worth spreading.

  5. #215
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

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

    Quote Originally Posted by teylyn View Post
    You're welcome. It's great tool and worth spreading.
    Here, here
    Rory’s gone……
    _ …… but his Tool Lives on

    _. May it continue to come up frequently for us.

    Alan

    P.s. …..


    Part of my My earlier Signature, ( currently suspended in favor of an important message )

    Post screenshots of your Spreadsheet Ranges that can be copied into a Spreadsheet
    -See bottom of the page (Win & Mac): http://excelmatters.com/excel-forums/
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv

    And a few other links to versions of the Add-In

    https://app.box.com/files/0/f/366413.../f_27863000440 ( XL 2007 + )
    https://app.box.com/files/0/f/366413.../f_32131854803 (XL 2010 + )

    Simple BB Borders code
    https://app.box.com/s/soezox25h3w0q5s4rcyl ( XL 2010 + )

    Simple Red BB Borders codes
    https://app.box.com/files/0/f/366413.../f_32560517515 (XL 2010 + )
    https://app.box.com/files/0/f/366413.../f_32629351849 (XL 2010 + )

    Note:
    When trying different Forum Tool ADD-Ins, always delete all versions form your computer entirely except the one you are trying. ( Otherwise Excel seem to decide which Add-In it uses regardless of the one you specify!!!! )


    http://www.mrexcel.com/forum/about-b...rder-help.html
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  6. #216
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4,260

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

    I uploaded the BB code earlier this morning then attempted to use it a little later when posting a solution. When I selected copy Excel quit responding and went into a recovery mode. When it started again the Forum Tools tab was gone, much the same as what had happened some time ago with PowerPivot 2010. I have an older laptop so maybe it is just a memory issue in which case there is probably nothing that can be done. I just wondered if anyone happens to have any ideas?
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  7. #217
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

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

    Hi JeteMc
    Quote Originally Posted by JeteMc View Post
    ...uploaded the BB code earlier this morning..... selected copy Excel quit responding and went into a recovery mode. When it started again the Forum Tools tab was gone,..... I just wondered if anyone happens to have any ideas?
    I have older computers and Excel versions... This crashing thing on running a program is happening a lot more often with me recently
    http://www.mrexcel.com/forum/general...l-crashes.html
    , but not specifically as a result of an Add-in attempt. Of course you realise that when the File recovers itself it it will either open your last saved File or , if it can, a more recent one it did automatically. So if you did not save the File, ( and i think importantly also you may need to save the Add-in when you have it selected in the VB Editor window, ) then it may be gone when Excel recovers.

    Maybe some ideas then:
    _1) As I mentioned in the above Thread, this strange crashing problem seems to be less apparent if I run a code in F8 once or twice the first times. If you are using the Rory Add-ins then that means
    open Module
    mBBCode
    in the VB Editor, ( Alt 11 )

    Put a stop beside
    Sub CopyRngToBBC(rInp As Range, bFrm As Boolean, bA1 As Boolean, bColour As Boolean)

    then run
    Sub ShowRangeToBBCForm()
    in debug mode. ( F8 )

    That may help, or at least in the debug mode you may see the error point where Excel is freaking out for you

    _2) You will find it a bit difficult to contact the author of these codes here. You may want to ask here:
    http://excelmatters.com/excel-forums/

    _3 ) If you are still having the problems with the Add-in for a BB Code generation, then maybe a simple "stand alone" Code could help get you by in the mean time. Check out these Posts for info and a File with some codes in.
    http://www.excelforum.com/developmen...ml#post4293889
    http://www.excelfox.com/forum/f17/te...2079/#post9635
    http://www.excelfox.com/forum/f13/bb...2077/#post9637

    and here the File again
    https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
    That one I keep up to date..

    The current one i also put in the attachment to this thread

    Hope that maybe of some help

    Alan
    Attached Files Attached Files

  8. #218
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

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

    Anyone know how to do this?

    Data Range
    A
    1
    10
    2
    20
    3
    30
    4
    40
    5
    50
    6
    ------


    This is the code generated for my table:


    HTML Code: 
    [size=1]Data Range
    [Table="class: grid"][tr][td] [/td][td][CENTER][B][COLOR=red]A[/color][/B][/CENTER][/td][/tr]
    [tr][td][CENTER][B][color=red]1[/color][/B][/CENTER][/td][td][COLOR="#000000"][RIGHT]10[/RIGHT][/COLOR][/td][/tr]
    
    [tr][td][CENTER][B][color=red]2[/color][/B][/CENTER][/td][td][COLOR="#000000"][RIGHT]20[/RIGHT][/COLOR][/td][/tr]
    
    [tr][td][CENTER][B][color=red]3[/color][/B][/CENTER][/td][td][COLOR="#000000"][RIGHT]30[/RIGHT][/COLOR][/td][/tr]
    
    [tr][td][CENTER][B][color=red]4[/color][/B][/CENTER][/td][td][COLOR="#000000"][RIGHT]40[/RIGHT][/COLOR][/td][/tr]
    
    [tr][td][CENTER][B][color=red]5[/color][/B][/CENTER][/td][td][COLOR="#000000"][RIGHT]50[/RIGHT][/COLOR][/td][/tr]
    
    [tr][td][CENTER][B][color=red]6[/color][/B][/CENTER][/td][td][COLOR="#FFFFFF"][RIGHT]------[/RIGHT][/COLOR][/td][/tr]
    [/table][/size]
    I want to use a background fill color on some of the cells. How do I do that?

    I've seen some example code but I can't get it to work. Probably not putting it in the correct location.
    Last edited by Tony Valko; 04-04-2016 at 01:21 PM.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  9. #219
    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?

    Testing.

    Edit Do you mean like this? Using RangeToBBCode V0.7.xlam

    Don't know which code change does the trick.

    Does this help?

    Row\Col
    A
    1
    10
    2
    20
    3
    30
    4
    40
    5
    50


    More edit

    HTML Code: 
    [size=2][Table="width:, class:grid"][tr][td]Row\Col[/td][td][CENTER]A[/CENTER][/td][/tr][tr][td][CENTER]1[/CENTER][/td][td][RIGHT]10[/RIGHT][/td][/tr]
    [tr][td][CENTER]2[/CENTER][/td][td="bgcolor:#FFFF00"][RIGHT]20[/RIGHT][/td][/tr]
    [tr][td][CENTER]3[/CENTER][/td][td][RIGHT]30[/RIGHT][/td][/tr]
    [tr][td][CENTER]4[/CENTER][/td][td="bgcolor:#A9D08E"][RIGHT]40[/RIGHT][/td][/tr]
    [tr][td][CENTER]5[/CENTER][/td][td][RIGHT]50[/RIGHT][/td][/tr]
    [/table][/size]
    Last edited by FlameRetired; 04-04-2016 at 01:35 PM.
    Dave

  10. #220
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

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

    HTML Code: 
    [td="bgcolor:#A9D08E"][RIGHT]40[/RIGHT][/td]
    That looks like what I need.

    Let me see what happens when I try it.

  11. #221
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

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

    Hi Tony
    Quote Originally Posted by Tony Valko View Post
    ........
    I want to use a background fill color on some of the cells. How do I do that?......
    Try out the last "Wonk" here ( At end of this Post: )
    http://www.excelforum.com/the-water-...ml#post4324451

    Alan
    Last edited by Doc.AElstein; 04-04-2016 at 01:35 PM.

  12. #222
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

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

    Data Range
    A
    1
    10
    2
    20
    3
    30
    4
    40
    5
    50
    6
    ------

  13. #223
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

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

    Looks good!

    Thanks!
    Last edited by Tony Valko; 04-04-2016 at 01:47 PM.

  14. #224
    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?

    Great. __________

    Thanks for the rep.

  15. #225
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

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

    Quote Originally Posted by Doc.AElstein View Post
    Try out the last "Wonk" here ( At end of this Post: )
    Yes, that also helped.

    Thanks!

+ Reply to Thread
Page 15 of 17 FirstFirst ... 5 13 14 15 16 17 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