Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: my test

  1. #11
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,352
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: my test

    Excel 2010#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    ABC
    1aaaaaa
    211231123
    3aaaaaa
    411241124
    5aaaaaa
    611251125
    7aaaaaa
    811261126
    9aaaaaa
    1011271127
    11aaaaaa
    1211281128
    13aaaaaa

    #DAE7F5 ;color: #161120">Sheet1



    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  2. #12
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,352
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: my test

    Excel 2010 32 bit#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    ABC
    1aaaaaa
    211231123
    3aaaaaa
    411241124
    5aaaaaa
    611251125
    7aaaaaa
    811261126
    9aaaaaa
    1011271127
    11aaaaaa
    1211281128
    13aaaaaa
    1411291129

    #DAE7F5 ;color: #161120">Sheet1



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">
    CellFormula
    #DAE7F5 ;color: #161120">C1=A1
    #DAE7F5 ;color: #161120">C2=A2
    #DAE7F5 ;color: #161120">C3=A3
    #DAE7F5 ;color: #161120">C4=A4
    #DAE7F5 ;color: #161120">C5=A5
    #DAE7F5 ;color: #161120">C6=A6
    #DAE7F5 ;color: #161120">C7=A7
    #DAE7F5 ;color: #161120">C8=A8
    #DAE7F5 ;color: #161120">C9=A9
    #DAE7F5 ;color: #161120">C10=A10
    #DAE7F5 ;color: #161120">C11=A11
    #DAE7F5 ;color: #161120">C12=A12
    #DAE7F5 ;color: #161120">C13=A13
    #DAE7F5 ;color: #161120">C14=A14

    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #13
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,352
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: my test

    Sheet2

    A
    1aaa
    21
    31
    41
    51
    61
    71
    81
    91
    101
    111
    12
    13
    142
    152
    162
    172
    18
    19
    203
    213
    223
    233
    24
    25
    264
    274
    284
    294
    304
    314
    324
    334
    344
    354
    364
    374
    384
    394
    404
    414
    424
    434
    44
    45
    465
    475
    485
    495
    505
    515
    525
    535
    545
    555
    565
    575


    Excel tables to the web >> Excel Jeanie HTML 4
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  4. #14
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,352
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: my test

    Excel 2010
    A
    1aaa
    21
    31
    41
    51
    61
    71
    81
    91
    101
    111
    12
    13
    142
    152
    162
    172
    18
    19
    203
    213
    223
    233
    24
    25
    264
    274
    284
    294
    304
    314
    324
    334
    344
    354
    364
    374
    384
    394
    404
    414
    424
    434
    44
    45
    465
    475
    485
    495
    505
    515
    525
    535
    545
    555
    565
    575

    Sheet2



    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com