+ Reply to Thread
Page 13 of 17 FirstFirst ... 3 11 12 13 14 15 ... LastLast
Results 181 to 195 of 243

How to post a range - headers and data?

  1. #181
    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 have a version here which doesn't use the DataObject (it uses API calls) and so shouldn't suffer from the 'two squares' issue on Win 8. It also has tools for posting using HTML which aren't much use here, but you can always simply take the clipboard code and use it in Marcelo's add-in instead of the DataObject code.
    Remember what the dormouse said
    Feed your head

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

    A test. Pray for me.

    Please Login or Register  to view this content.
    OK; that works...sort of. Cannot find those BB code tags.
    Help?
    Last edited by FlameRetired; 09-02-2014 at 10:20 PM.

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

    New test:

    A
    B
    C
    D
    1
    Jupiter Wyoming
    -16
    2
    Saturn Alabama
    20
    3
    Uranus Alaska
    -10
    4
    Neptune Arizona
    -8
    5
    Pluto Arkansas
    15
    6
    Mercury California
    15
    7
    Venus Colorado
    5
    8
    Earth Connecticut
    -14
    9
    Mars Delaware
    4
    10
    Jupiter Florida
    6
    11
    Saturn Georgia
    -5
    12
    Uranus Hawaii
    -7


    That worked except for the colors. I keep trying.

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

    One more time:

    A
    B
    C
    D
    1
    Jupiter Wyoming
    -16
    2
    Saturn Alabama
    20
    3
    Uranus Alaska
    -10
    4
    Neptune Arizona
    -8
    5
    Pluto Arkansas
    15
    6
    Mercury California
    15
    7
    Venus Colorado
    5
    8
    Earth Connecticut
    -14
    9
    Mars Delaware
    4
    10
    Jupiter Florida
    6
    11
    Saturn Georgia
    -5
    12
    Uranus Hawaii
    -7


    That's great!! Thank you Marcelo and all. I will use this.
    FR
    Last edited by FlameRetired; 09-03-2014 at 09:39 AM.

  5. #185
    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?

    'Nother test......
    E
    F
    G
    H
    I
    J
    9
    10
    Customer
    Product Qty
    11
    Corks
    Bottles
    Barrels
    12
    Contoso, Ltd.
    14
    9
    3
    13
    Coho Winery
    2
    11
    15
    14
    15
    16
    Price
    Weight (lbs)
    Product
    17
    $200
    4
    Corks (500/box)
    18
    $250
    42
    Bottles (case)
    19
    $425
    115
    Barrel
    20
    MMULT
    21
    Customer
    Sales
    Total weight
    22
    Contoso, Ltd.
    $6,325
    779
    #N/A
    23
    Coho Winery
    $9,525
    2195
    #N/A
    24
    #N/A
    #N/A
    #N/A
    25

  6. #186
    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?

    You testing the tests? lol

    @ Rory, thanks for that, I had not noticed your post before. I an on W7 right now, will take a look when I get home (W8)
    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

  7. #187
    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?

    deleted duplicate post
    Last edited by FDibbins; 09-22-2014 at 07:49 PM.

  8. #188
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    38,470

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

    Version 0.5 adds options to suppress the header and grid:

    Statement
    Statement
    Statement
    Statement
    Remark
    Marker
    Operator
    Call Else Loop Sub Rem Any AddressOf
    Case ElseIf LSet Type As And
    Close End Next Unlock ByRef Eqv
    Const EndIf On Wend ByVal Imp


    The add-in is at https://app.box.com/s/soezox25h3w0q5s4rcyl
    Entia non sunt multiplicanda sine necessitate

  9. #189
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    38,470

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

    Is anyone having problems with the add-in in Excel 2013?

  10. #190
    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 the issue is Windows 8, not XL 2013, as cropped up in posts 142, 147 and with the version posted by romperstomper in post 181. That one works fine in Win 8.

  11. #191
    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?

    to confirm, I have used Rompers suggestion from post 181 in Win8 and (now) win 8.1 at home, and it does work great, still using win 7 at work here though

    My apologies Rory, I thought I had thanked you for this before, but looking back, apparently I did not - so thank you bunches for that

  12. #192
    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?

    You're welcome, Ford.

  13. #193
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    38,470

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

    I think that is an apalling bug.

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

    What would you expect from an appalling OS?

  15. #195
    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
    I have a version here
    Hi Rory,

    I am using your addin for posting the table for OP's and it's working fine and thanks for it

    One small missing piece is that it's showing the Normal formula and Array Formula in the same way... without covering the formula with curly braces {} for array formulas...

    Here is the thread as an example

    http://www.excelforum.com/excel-form...-of-pairs.html

    If you implement it then it will be very much useful to me and OP as well


    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

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