Search:

Type: Posts; User: mc136355; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    174

    Re: New table if count is larger than 20

    Hi have gathered the following code:

    Sub insertbreak()

    Dim tbl As ListObject
    Set tbl = ActiveSheet.ListObjects("Table1")
    If tbl.DataBodyRange.Rows.Count <= 20 Then
    MsgBox "do...
  2. Replies
    4
    Views
    174

    New table if count is larger than 20

    Hi

    I have a spreadsheet that uses code to insert rows into my table based on a cell value. My problem is the cell value can be over 100 and i would like to somehow break the table up if value is...
  3. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Hi Akuini both codes produce the same result which is what i need formulas are copied as expected. Thanks MC
  4. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Akuini the code that you have provided seams to resolve this issue. At the moment i cant seam to find any further issue. Thanks MC
  5. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Before code

    <colgroup><col style="mso-width-source:userset;mso-width-alt:4142;width:178pt" width="237"> </colgroup><tbody>
    COUNT



    =COUNTIF(F$15:F15,F15)
  6. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Hi

    i apologise the date is a formula but i realise it needs to be absolute ref. i have =C2 should be =$C$2 OOps MC
  7. Replies
    33
    Views
    946

    Re: VBA to insert rows

    <colgroup><col style="mso-width-source:userset;mso-width-alt:3537;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:3840;width:83pt" width="110"> <col...
  8. Replies
    33
    Views
    946

    Re: VBA to insert rows

    thought i was in the wrong thread sorry

    Hi igold
    The issue with this one is that the code line

    .ListRows(1).Range.PasteSpecial xlPasteAll

    copies into the first row but moves everything...
  9. Replies
    33
    Views
    946

    Re: VBA to insert rows

    wrong post sorry
  10. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Hi igold

    Thanks for the help. You are totally correct about formula not getting copied down. However with the new code you have supplied it runs and insert the lines i need but this one for some...
  11. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Hi igold

    Code works really well. The only problem is it seems to take a long time to add 5 rows and there is a lot of flickering. Obviously not the code. Would you have any suggestions thanks MC
  12. Replies
    33
    Views
    946

    Re: VBA to insert rows

    Table is called medline thanks MC
  13. Replies
    33
    Views
    946

    VBA to insert rows

    Hi ive searched google to try and find answer to my problem but there are similar questions but dont know how to manipulate the vba to suit me.

    My problem is i need to achieve the following
    i...
  14. Thread: tidy vba

    by mc136355
    Replies
    4
    Views
    140

    Re: tidy vba

    Thanks for your help Steve. Cuts the vba down but still looking untidy. Will need to learn how to set out vba, which might help. thanks again MC
  15. Thread: tidy vba

    by mc136355
    Replies
    4
    Views
    140

    Re: tidy vba

    Thanks for the quick reply Steve. Will check this out tomorrow when i finish work. Thanks again MC
  16. Thread: tidy vba

    by mc136355
    Replies
    4
    Views
    140

    tidy vba

    Hi ive recorded a macro to transpose a cell contain text and then use in a validation. The code works fine but is really messy and i would just like to tidy it up. Wonder if there is any other code...
  17. Replies
    3
    Views
    76

    Re: inventory values to update

    Hi MB thanks for the quick reply. Looks like this has done the trick and is working on both columns. Thanks for your time. MC
  18. Replies
    3
    Views
    76

    inventory values to update

    Hi I am trying to update values in an inventory sheet but if value has no change then i cannot create a formula to show the previous value. Any help would be appreciated. Hope this makes sense....
  19. Replies
    4
    Views
    358

    Re: string used to hide sheets

    Hi All
    Just 1 further problem with my code. When I get to unhiding the sheets it seams to unhide all but then attempts to unhide an extra one which is blank (blank input box). is there anyway I can...
  20. Replies
    4
    Views
    358

    Re: string used to hide sheets

    Hi thanks for replies

    Took my code as you suggested and put it into sub as per nosparks code. (will learn more about functions and sub routines as I go)

    The code is ideal

    Thanks to both for...
  21. Replies
    4
    Views
    358

    string used to hide sheets

    Hi guys

    looking for a hint on what my problem is with the following code.
    I searched all worksheets and pulled back 3 sheets beginning with 1234567 which are in a string
    I need to now unhide...
  22. Re: determine how many elements an array will have

    Hi Dave

    Thanks for your help as a newbie I get quite confused with what is an array variable etc. and how to manipulate.
    I will endeavour to keep learning and improve my knowledge.

    code is...
  23. Re: determine how many elements an array will have

    Thanks for reply

    Hi test3 is a sheet in the same workbook from which I pull my data from

    Rgds
    MC
  24. Re: determine how many elements an array will have

    Hi again bit stuck on getting the following code to work

    first part works and goes to function but I then get subscript out of range

    cant understand the problem


    Private Sub...
  25. Re: determine how many elements an array will have

    Thanks for replies

    Both bits of code work great and will be using in my code

    MC
Results 1 to 25 of 36
Page 1 of 2 1 2