+ Reply to Thread
Page 2 of 17 FirstFirst 1 2 3 4 12 ... LastLast
Results 16 to 30 of 243

How to post a range - headers and data?

  1. #16
    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 FDibbins View Post
    your code looked fine to me?
    Can you see the entire code? I cannot (???) ---> using IE10

    I can see only using Reply With Quote. Is it a normal behavior?
    Marcelo Branco

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

    Let me try Marcelo's code...

    A B C D
    1 Name Region Sales
    2 Pat North 100
    3 Put East 200
    4 Pit South 300
    5 Pot West 400
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

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

    Hmmm...

    I messed up and made the range A1:D5 which is why that empty column is in there.

    Here it is again with the correct range A1:C5...

    A B C
    1 Name Region Sales
    2 Pat North 100
    3 Put East 200
    4 Pit South 300
    5 Pot West 400

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

    This looks very promising.

    Nice job, Marcelo!

  5. #20
    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 mlcb View Post
    Can you see the entire code? I cannot (???) ---> using IE10

    I can see only using Reply With Quote. Is it a normal behavior?
    No, I can't see it either in IE9 but I was able to get all of it doing the "Reply With Quote" trick.

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

    Some more testing...

    Pat North 100
    Put East 200
    Pit South 300
    Pot West 400

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

    More testing...

    Name Date In Out
    Pat 8/24/2013 7:05 AM 3:55 PM
    Put 8/24/2013 6:48 AM 3:05 PM
    Pit 8/24/2013 7:00 AM 3:30 PM
    Pot 8/24/2013 7:08 AM 3:17 PM


    Name Date In Out
    Pat 8/24/2013 7:05 AM 3:55 PM
    Put 8/24/2013 6:48 AM 3:05 PM
    Pit 8/24/2013 7:00 AM 3:30 PM
    Pot 8/24/2013 7:08 AM 3:17 PM

  8. #23
    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
    This looks very promising.

    Nice job, Marcelo!
    Wow... it works!!!

    Thank you, Tony

    M.

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

    Some more testing...

    Name Date In Out
    Pat 8/24/2013 7:05 AM 3:55 PM
    Put 8/24/2013 6:48 AM 3:05 PM
    Pit 8/24/2013 7:00 AM 3:30 PM
    Pot 8/24/2013 7:08 AM 3:17 PM

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

    Testing using Font colors

    A B
    1 Name Scores
    2 John 30
    3 Mary 32
    4 Mike 34
    5 William 36

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

    Follows the code

    Use Reply with Quote to see the entire code

    Please Login or Register  to view this content.

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

    a b
    1 9 59
    2 10 37
    3 8 76
    4 83 95
    5 49 6

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

    a b
    1 9 59
    2 10 37
    3 8 76
    4 83 95
    5 49 6

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

    Wonder why the column headers are showing in lowercase?

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

    A B
    1 Data Data
    2 Data Data
    3 Data Data
    4 Data Data
    5 Data Data


+ Reply to Thread
Page 2 of 17 FirstFirst 1 2 3 4 12 ... 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