Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: VBA do not allow to save if row count does not match

    Thank you so much! One las think how to amend this to run on every worksheet in workbook?
  2. Re: VBA do not allow to save if row count does not match

    OK I got it it work with numbers, how to adjust this code to check the count of no n empty cells? I might have string fields in dat set mixed with numebrs
  3. Re: VBA do not allow to save if row count does not match

    Hi,

    Thank you for prompt reply, I pasted it into VBA editor but got no idea why it does not work, still allows me to save

    https://ibb.co/6vXgYd3


    https://ibb.co/6vXgYd3
  4. VBA do not allow to save if row count does not match

    Hi,

    I am looking for a code that would prevent user from saving the file if count of no empty cells in column "E" is different than in columns "F"-"AE"

    Any ideas?? I tried with below but failed...
  5. Re: VBA: Split data into multiple worksheets based on column

    Hi All, this simplified version works perfect. I was wondering if it is possible to set a limit on how many rows can each work sheet contain? I mean each sheet should contain max 25k of unique rows....
  6. Re: VBA to find the same value and copy range in different sheets

    Thanks for help. I finally got it work. Maybe someone will find this useful, here is my entire code:


    Sub myMacro()
    Dim i As Integer
    Sheets("AAAAA").Activate
    For i = 7 To...
  7. Re: VBA to find the same value and copy range in different sheets

    thanks, so close but still not working ;/ runtime error
  8. Re: VBA to find the same value and copy range in different sheets

    Thank you. I have played around with it my code:


    Sub myMacro()
    Dim i As Integer
    Sheets("ZZZZZ").Activate
    For i = 7 To Range("A7").End(xlDown).Row

    'Filtrowanie
  9. Re: VBA to find the same value and copy range in different sheets

    Thank you very much for help. Are you able to advise how to code the "copying"" part??


    Sub myMacro()
    r = 2
    Do Until r > Sheet1.Range("A" & Rows.Count).End(xlUp).Row
    rr = 2...
  10. VBA to find the same value and copy range in different sheets

    Hi All,

    I have trouble to figure out the right way to code the issue below:

    Let's say on Sheet1 I have:


    <tbody>
    Value
    Code
  11. Replies
    3
    Views
    111

    Re: Autofilter not working after code split

    Hi, thanks for quick reply.

    It is Runtime Error '1004'. Application-defined or object efined error.

    Line is


    ActiveSheet.Range("$A$5:$M5").AutoFilter Field:=10,...
  12. Replies
    3
    Views
    111

    Autofilter not working after code split

    Hi All,

    I have a problem I am working on a huge macro and had to split some of it into separate macros due to the "Too large" error. The following is working when it's a part of the main code. But...
  13. Re: VBA - Define as one range cells with the same value

    The problem is that they cannot be really sorted. Only first column containt data that can be sorted.

    I mean the entire table would look like:


    <tbody>
    Code
    Something 1
    Somethin 2
  14. VBA - Define as one range cells with the same value

    Hi All,

    I have a question..Let's assume I am writing a code and I have a Column which looks like that:

    1
    1
    2
    2
    3
    3
  15. Replies
    5
    Views
    219

    Re: VBA - Loop not checking conditions

    Topic can be closed. I added another


    Sheets("Sheet1").Activate

    After "For" statement
  16. Replies
    5
    Views
    219

    Re: VBA - Loop not checking conditions

    Hi,

    Still no luck. However I tried to code it on smaller amount of data and I think I know where the issue comes from:


    Sub test()

    Dim i As Integer
  17. Re: Problem with Offset, unable to get thew right Syntax

    Hi Rick sorry for my late response. I just checked it (sorry I did not notice your post before). Code provided by you works, it copies the required range but with headers.
  18. Replies
    5
    Views
    219

    Re: VBA - Loop not checking conditions

    Thanks for quick reply, but now the code just runs and does nothing.

    I have written a second version:


    Sub split()

    Dim i As Integer
  19. Replies
    5
    Views
    219

    VBA - Loop not checking conditions

    Hi All,

    I have a problem with loop in my code:


    Sub test2()

    Dim i As Integer
    i = 1
  20. Re: Problem with Offset, unable to get thew right Syntax

    Thank you all for help, topic can be closed.

    Issue solved with the following line:


    Range(Range("a6"), Cells(Rows.Count, "g").End(xlUp)).SpecialCells(xlVisible).Copy
  21. Re: Problem with Offset, unable to get thew right Syntax

    Thanks but still no luck. I tried to add "-6" to the code but it did not help

    This is how it looks now


    Sheets("Tab2").Select
    Rows("5:5").Select
    range("K5").Activate
    ...
  22. Re: Problem with Offset, unable to get thew right Syntax

    Positive 6 copies values starting from column G ;/ I need to copy column range from A to G. Values are filtered that's why there is an offset of 5 to copy without headers.
  23. Re: Problem with Offset, unable to get thew right Syntax

    thank you for reply.

    It gives $A$1:$r$18

    I want it to copy from column A to G
  24. Problem with Offset, unable to get the right Syntax

    Hi All,

    I have a trouble with the following line of the code:


    Sheets("Tab2").Select
    Rows("5:5").Select
    range("K5").Activate
    Selection.AutoFilter
    ...
  25. Replies
    0
    Views
    187

    Macro problem with If statement.

    Hi All,
    I am working on some VBA code and got stuck with "If" statement.
    In general I want macro to filter proper columns basing o cell values and copy paste the result to another tab. This is my...
Results 1 to 25 of 31
Page 1 of 2 1 2