+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 201 to 243 of 243

How to post a range - headers and data?

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

    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!
    Remember what the dormouse said
    Feed your head

  2. #202
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    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 someone helped you

    Regards
    Ford

  3. #203
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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.

  4. #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

  5. #205
    Forum Expert 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,744

    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.

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

    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)

  7. #207
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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)

  8. #208
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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?

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

    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/

  10. #210
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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)

  11. #211
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    Romper, I have tried that link again, but it doesnt seem to be working?

  12. #212
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    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

  13. #213
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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

  14. #214
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

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

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

  15. #215
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    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 )

  16. #216
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    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.

  17. #217
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    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

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

    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: 
    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.

  19. #219
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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: 
    Last edited by FlameRetired; 04-04-2016 at 01:35 PM.
    Dave

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

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

    HTML Code: 
    That looks like what I need.

    Let me see what happens when I try it.

  21. #221
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    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.

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

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

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

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

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

    Looks good!

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

  24. #224
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    Great. __________

    Thanks for the rep.

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

    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!

  26. #226
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

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

    Hi Tony
    Quote Originally Posted by Tony Valko View Post
    Yes, that also helped.
    Thanks!
    Yous welcome, tzhanks for Rep Thiungy
    Wonk Wonk

  27. #227
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

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

    Quote Originally Posted by Tony Valko View Post
    Anyone know how to do this?

    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.
    Hi Tony

    This?


    A
    B
    C
    1
    Carro
    Motor
    Cor
    2
    Carro1
    Motor1
    Cor1
    3
    Carro2
    Motor2
    Cor2
    4
    Carro3
    Motor3
    Cor3
    5
    Motor4
    Cor4
    6
    Cor5
    7
    8
    9
    Qt Carros
    Qt Motores
    Qt Cores
    10
    3
    4
    5
    11


    Updated version

    HTML Code: 
    Greetings

    M.
    Marcelo Branco

  28. #228
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    Greetings Marcelo,

    While this thread is active again I have another question.

    After using the macro and that workbook is still open, I attempt to use it on another workbook the previous selection gets selected.

    How do we clear previous selections without closing that workbook?

    Thanks,
    Dave

  29. #229
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

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

    Marcelo,

    Thanks for the updated code.

    I'll have to "tinker around" with it and see how it works.

    Hope Ford also sees this as he's been wanting to know which version of the code is the most up to date.

    Thanks!

  30. #230
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

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

    @Dave

    Quote Originally Posted by FlameRetired View Post
    ......
    After using the macro and that workbook is still open, I attempt to use it on another workbook the previous selection gets selected.

    How do we clear previous selections without closing that workbook?.....
    That is weird ?? That has never happened to me with any BB Code Generator.
    Every time you run the code, the current selection is converted to BB Code and put in the clipboard... or so I thought. Make sure no codes anywhere are still running in deBug, or that nothing anywhere is waiting for a carriage return ( Enter ) - I have found that those two things prevent anything being copied to the clipboard. That could explain why it worked when you closed the previous File. - Maybe something was still "active" in that file which got killed when you closed it

    Alan
    _.................

    @Marcelo and Tony.
    That code form Marcelo works great..
    _.. added it to my “collection”
    https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9


    ( And dropped an Edit to Ford..
    http://www.excelforum.com/the-water-...ml#post4354756
    Now he’ll be really confused!!.. lol )

    Alan
    Last edited by Doc.AElstein; 04-04-2016 at 06:51 PM.

  31. #231
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    Thanks, Alan.

    In previous versions resetting in VBA editor usually did the trick. Something happened along the way and that doesn't work for me anymore.

    If those things you listed are the issue it means I do that every time. That's a lot of coincidences. I also don't run macros / UDFs that often ... except for this one.

    Kept looking for a way to insert some kind of clearing code in the macro. Never found it. My knowledge of VBA is very thin ... I can spell VBA ... most days. LOL

    I've never found a link that covers this one. Ford raised the question early on, too. No response.

    Thanks again,
    Dave

  32. #232
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

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

    Hi Dave
    Quote Originally Posted by FlameRetired View Post
    .... previous versions resetting in VBA editor usually did the trick. Something happened along the way and that doesn't work for me anymore........
    I've never found a link that covers this one. Ford raised the question early on, too. No response....e
    Ok something weird then. Sorry i could not help. I am no VBA expert either.

    Maybe Marcelo or another one of the people who wrote these codes will get back to you on this one...
    _... But i do know that...
    _ in VBA, this normally clears the clipboard
    Application.CutCopyMode = False
    _ . and strangely i notice in Marcelo‘s most recent code he has this line, but he has it commented out...
    'Application.CutCopyMode = False

    And other codes have a
    Declare Function EmptyClipboard Lib "User32" () As Long
    And later in the code...
    _______ ' Clear the Clipboard.
    ______ X = EmptyClipboard()

    But i am out of my depth here and do not know what all that stuff is about.... !!! I only ever did very simple mods to the Codes from the Pros
    _........

    Hope you get it sorted..

    Alan

    P.s.I can tell you one other weird thing about Add-Ins to be careful of:
    I sometimes found that when i was trying out the various Add-Ins that sometimes VBA did weird things and decided itself which Add-In to run, regardless of the one I had selected.
    And the File name and the name seen in the Add-In list was sometimes different. So I sometimes found it was necessary to delete all BB Code Add-ins ( everywhere ! ) on my computer except the one i wanted to use so as to be sure that VBA “chose” the one i wanted!!). That is one reason why i went a bit away fron the Add-Ins, and turned them into “Stand alone codes”.. which I have a messy collection of in the file i linked.

  33. #233
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

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

    Using the code in two workbooks

    New version - observe the code line
    Application.CutCopyMode = False


    HTML Code: 

    Testing...

    Workbook 1


    A
    B
    1
    Names
    Scores
    2
    Anthony
    10
    3
    John
    20
    4
    Mary
    30
    5
    Richard
    40
    6
    Robert
    50


    Workbook2


    A
    B
    1
    SKU
    Price
    2
    1001
    10
    3
    1002
    12
    4
    1003
    14
    5
    1004
    16
    6
    1005
    18

  34. #234
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    Thank you, Marcelo.

    I'm clueless, though.

    Please tell me what I need to do with this? Where do I put what?

    Do I need to edit / rename anything besides insert the "Application.CutCopyMode = False" line?


    My VBA knowledge is zero.

    Thank you, again.

    Dave

  35. #235
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    @ Doc.AElstein

    Thank you, again.

    Maybe Marcelo will enlighten us both.

    I think I need a "seeing-eye-programmer"! LOL

    Dave

  36. #236
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

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

    Put the code in Personal Workbook - see the link below

    How to create a Personal Workbook
    http://www.rondebruin.nl/win/personal.htm

    You can find in the internet many tutorials/videos about VBA
    Some links
    http://www.easyexcelvba.com/introduction.html

    http://chandoo.org/wp/2011/08/29/int...to-vba-macros/

    http://www.ozgrid.com/Excel/free-tra...ba1lesson1.htm

  37. #237
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

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

    Ignore this post
    Last edited by mlcb; 04-04-2016 at 10:47 PM.

  38. #238
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    Quote Originally Posted by FlameRetired View Post
    Greetings Marcelo,

    While this thread is active again I have another question.

    After using the macro and that workbook is still open, I attempt to use it on another workbook the previous selection gets selected.

    How do we clear previous selections without closing that workbook?

    Thanks,
    Dave
    I have the same problem- sometimes, but only at home where I use W10 and office 13 (office 16 now)

  39. #239
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    From Tony...
    Hope Ford also sees this as he's been wanting to know which version of the code is the most up to date.
    yes I did, thank you

    From Doc (Alan)...
    ( And dropped an Edit to Ford..
    http://www.excelforum.com/the-water-...ml#post4354756
    Now he’ll be really confused!!.. lol )
    confused is my middle name - so nothing new there lol

    OK with that new code from Marcelo (post 227), do I replace whatever I had for posting tables, with that code?

  40. #240
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

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

    Quote Originally Posted by FDibbins View Post
    ......
    OK with that new code from Marcelo (post 227), do I replace whatever I had for posting tables, with that code?
    Hi Ford.
    Not sure who you are asking. And i am nor sure what "code" ( or Add-In ) you are currently using.
    But i just had another go at trying to clarify things a bit as far as i understand them for you:
    http://www.excelforum.com/the-water-...ml#post4355240
    Alan
    Last edited by Doc.AElstein; 04-05-2016 at 08:11 AM.

  41. #241
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

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

    Hi Dave
    _1) First Just some extra quick info in addition to that from Marcelo on VBA Learning:
    _a) These Threads has some good you Tube play lists... video series etc...
    http://www.excelforum.com/excel-gene...ml#post4272300
    http://www.eileenslounge.com/viewtop...175146#p175146
    _b) the list of learning material that hiker95 often makes is a bit big.. but he tries to include the best he knows
    http://www.mrexcel.com/forum/excel-q...ml#post4379195
    http://www.mrexcel.com/forum/excel-q...ml#post4379209
    _.................................................................................


    _2 ).........
    _..........................
    Quote Originally Posted by FlameRetired View Post
    .......
    Please tell me what I need to do with this? Where do I put what? .......
    Do I need to edit / rename anything besides insert the "Application.CutCopyMode = False" line?
    .........
    My VBA knowledge is zero.......
    I think I need a "seeing-eye-programmer"
    .....................
    _........................

    Marcelo will probably confirm , but i think, he just put back in the line
    Application.CutCopyMode = False
    _ .. that is to say he edited just that line to take out the took the ' ( - you probably know a ' has the effect of making everything after it on that line turn into comments, that is to say just notes for your convenience, which VBA just ignores. So rather than removing a line, often one “comments them out” by putting a ' before. That way you can put the line back in later if you then change your mind. Or alternatively it just serves as a bit of documentation as a reminder for you as to what you did. )

    It is always difficult to help not knowing exactly what level you are. I try:

    Basically we are talking about two different things. A) Add-Ins and B) what i call “stand alone codes”

    _A) Add-Ins

    Add-Ins are more “user friendly” things, ( at least once you have them installed !! installing can be very user unfriendly lol !! )). Once there you have something extra up in the Ribbon bar and you click on it and then a Message box prompts you etc.. etc... etc.......
    If you go for the “Add-In option”, then Probably Rory’s is the best to go for. I think He has complied together , added to , improved etc.. codes from the likes of Marcelo Branco, Tony Valko, Jon von der Heyden, Peter (VoG), and Stephen Gersuk ( and i apologise if i have missed anyone. )
    Current Add-in and some ( badly) written notes from me on how to install an Add-In for example here:

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

    Notes:
    http://www.excelforum.com/the-water-...ml#post4109080
    http://www.excelforum.com/developmen...ly-needed.html
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv

    (-..also ... Jon von der Heyden did some notes on a specific HTML Code Generator Add-In that is not supported here at Excel Forum, but again it may give you an idea how to install an Add-in
    http://www.mrexcel.com/forum/about-b...ml#post2507729
    _.... )
    _...............................................................


    _B ) “Stand Alone Codes”

    An example of this is what Marcelo presented yesterday. That is one of a few codes that would probably be incorporated into one of those Add-Ins.

    Again i do not know your exact level of VBBA knowledge.
    This is the typical gem given to beginners....

    How to get a macro up and running:

    (IMPORTANT: always save your File just before you run any macro. –This is Because you cannot use the Excel backward thing to clear any changes made by a macro.
    (Actually When you “work on your File” you effectively work on a copy of your File. It only becomes your file when you save http://www.mrexcel.com/forum/excel-q...ml#post4425428 ...._)
    _ - So If anything goes wrong after running a macro, then simply close the file without saving, then open it and no damage will have been done to your original File. )

    To Install a macro:
    1. Copy the code given to you to the clipboard. ( Highlight code and Hit Ctrl C )
    2. Open a NEW workbook ( or the workbook you want the code in )
    3. Press the keys ALT + F11 to open the Visual Basic Editor
    At this point you should see the cursor flashing in a big empty window
    ( If not then select from the VB Editor ribbon ---- Insert ------ module )
    4. Where the cursor is flashing, paste the code
    5. Do any editing of the code you wish to at this stage.
    6. Press the keys ALT + F11 to return to Excel ( or press ALT and q simultaneously to close the VB Editor )

    To run or wonk or work on a macro:
    7. When in Excel, press ALT + F8 to display the Run Macro Dialog Window Box Thing.
    8. You can choose to run the code ( alternatively Double Click the macro's name to Run it.)
    Or
    9. You can choose to work ( or wonk** ) on it. – This option is good to find the macro if you have many and are not sure where they all are )

    ( **a wonk is what i do on the Pros codes.. in other words i ruin them for my own perverse pleasure lol )
    _................................

    You may want as an alternative to putting the code in a particular File, to create a PERSONAL.XLSB, and ADD a button to ribbon ( XL 2010 + ) or ADD a quick access symbol XL 2007 +.
    ( That way it is similarly to the Add-In "always there " for you when you open Excel )

    For that i cannot explain it better than the Link Marcelo gave you
    http://www.rondebruin.nl/win/personal.htm
    Or you may find mine and Jerry’s instructions a bit quicker to follow:
    http://www.excelforum.com/tips-and-t...ml#post4109262
    http://www.excelforum.com/the-water-...ml#post4110298

    _...............................................

    Some other “Alan options”!!!!

    _ C) I “collect” all these codes in this file
    https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
    So just play with that, running for example this code ( Found from Excel as in the above instructions 7. above )
    Sub ShowRangeToBBCFormJune()

    ( I assume that you know that the start point before running any BB Code Generating Add-In or “stand alone code” is to highlight the range you want to show in a Forum Post. That Range is then converted to a BB Code to produce a Table and that code placed in the Clipboard. You then paste in the Forum Editor ..
    _ – Practice pasting in here
    http://www.excelforum.com/development-testing-forum/
    And here:
    http://www.mrexcel.com/forum/test-here/

    _............

    _D) Last just for Fun . For you and Ford as you were over there more recently, ( where the Post editor is kinder and allows a lot at once to be pasted:......
    http://www.mrexcel.com/forum/test-he...ml#post4480787
    ( but note, that Thread will likely be routinely deleted in a few days )



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

  42. #242
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

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

    Test new code...


    A
    B
    C
    1
    Type
    Amount
    Y/N
    4
    Data3
    82
    N
    5
    Data4
    84
    N


    Range has autofilter applied

  43. #243
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

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

    Just testing


    A
    B
    1
    E
    FALSE
    2
    H
    3
    H
    FALSE
    4
    K
    5
    A
    FALSE
    6
    Y
    7
    E
    TRUE
    8
    E
    9
    U
    FALSE
    10
    J
    11
    G
    FALSE
    12
    T
    13
    H
    FALSE
    14
    A
    15
    Y
    FALSE
    16
    V
    17
    B
    FALSE
    18
    Q
    19
    A
    FALSE
    20
    B
    21
    I
    FALSE
    22
    O
    23
    O
    FALSE
    24
    U
    25
    T
    TRUE
    26
    T

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dependent drop down lists- dynamic data range- excluding Headers
    By strud in forum Excel General
    Replies: 3
    Last Post: 05-28-2013, 04:10 AM
  2. [SOLVED] INDIRECT will not post Text string to Data Validation for Named Range on another Workbook
    By carleaston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2012, 05:08 PM
  3. ClearContents all rows except headers in a dynamic range
    By jdfjab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2012, 02:24 PM
  4. Replies: 3
    Last Post: 09-30-2010, 12:30 PM
  5. Creating Headers within a date range
    By orivera in forum Excel General
    Replies: 1
    Last Post: 07-25-2008, 07:22 PM

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