+ Reply to Thread
Page 12 of 17 FirstFirst ... 2 10 11 12 13 14 ... LastLast
Results 166 to 180 of 243

How to post a range - headers and data?

  1. #166
    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 for the feedback!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  2. #167
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,632

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

    Made my own variant:
    If the selection is 1 cell it will be expanded to the currentregion, otherwise the selection will be converted into a HTML table.

    Please Login or Register  to view this content.
    The function can't be posted here because it's been evaluated as html.
    Attached Files Attached Files
    Last edited by snb; 05-10-2014 at 08:41 AM.

  3. #168
    Registered User
    Join Date
    06-25-2013
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    51

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

    Quote Originally Posted by snb View Post
    Made my own variant:
    If the selection is 1 cell it will be expanded to the currentregion, otherwise the selection will be converted into a HTML table.

    Please Login or Register  to view this content.
    The function can't be posted here because it's been evaluated as html.

    This gives me a small excuse to ask about this line:
    With GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")

    I don't need to fully understand it, but would appreciate at least a short explanation of what's going on with this line of code.

    I apologize if it's already been explained in this thread. I read the first couple pages of this thread, then skipped to the (previously) last page of the thread

  4. #169
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,632

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

    see also #160

    it's creating a new instance of the dataobject, based on the reference Msforms 2.0



  5. #170
    Registered User
    Join Date
    06-25-2013
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    51

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

    Quote Originally Posted by snb View Post
    see also #160

    it's creating a new instance of the dataobject, based on the reference Msforms 2.0
    Yes, I got it from post #160 which is where I first became curious as to what it meant. Cool. Thanks for the info. The macro containing it works nice.

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

    Testing font color...

    Data Range
    A
    B
    1
    1
    8
    2
    2
    2
    3
    8
    7
    4
    3
    3
    5
    8
    5
    6
    8
    4
    7
    4
    4
    8
    5
    6
    9
    8
    9
    10
    6
    5

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

    Testing font color...

    Data Range
    A
    B
    1
    1
    8
    2
    2
    2
    3
    8
    7
    4
    3
    3
    5
    8
    5
    6
    8
    4
    7
    4
    4
    8
    5
    6
    9
    8
    9
    10
    6
    5

  8. #173
    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?

    One last test of font color...

    Data Range
    A
    B
    1
    1
    8
    2
    2
    2
    3
    8
    7
    4
    3
    3
    5
    8
    5
    6
    8
    4
    7
    4
    4
    8
    5
    6
    9
    8
    9
    10
    6
    5

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

    Testing font color...

    Data Range
    A
    B
    1
    61
    15
    2
    78
    67
    3
    1
    36
    4
    94
    72
    5
    22
    49
    6
    91
    63
    7
    69
    35
    8
    27
    71
    9
    46
    63
    10
    60
    30

  10. #175
    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?

    Hay Tony, was that the last after-last last test?
    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

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

    There might be more!

    I'm trying to come up with the best color combinations where the row/column headers standout and I can highlight specific pieces of the data so they also standout.

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

    I know I have said this before in this thread (somwhere in the 12 pages???), but what is the latest itteration of this now, and where/how can it be found?

    This really really helps a LOT when posting answers, and it would be great to keep it updated with the latest version

    Also, when running this (the version I have) on W8 and 2007 or 2010, sometimes it just pastes 2 small squares instead of the table - any fix for that?
    Last edited by FDibbins; 09-22-2014 at 07:25 PM. Reason: fixed reaqlly bad spelling

  13. #178
    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?

    Without going through the entire thread (again) I can't tell you which is the latest update.

    I can post the code I use if you want me to.

    As for the problem you mentioned...I've not experienced anything like that but I use Win7.

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

    Entia non sunt multiplicanda sine necessitate

  15. #180
    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?

    Yup, I only have that on W8, not W7 (both running 2007)

    I started at post # 142 on page 10

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