+ Reply to Thread
Page 17 of 17 FirstFirst ... 7 15 16 17
Results 241 to 243 of 243

How to post a range - headers and data?

  1. #241
    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 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.
    '_- 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 )

  2. #242
    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?

    Test new code...


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


    Range has autofilter applied
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

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

    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
    Dave

+ Reply to Thread
Page 17 of 17 FirstFirst ... 7 15 16 17

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