• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Protect pivot, but only allow Expand/Collapse

    Hey, i need to protect pivot from changing, but allow to Expand/Collapse. Is it possible please? Thanks. Tomas
  2. F

    Add weekend values to weekdays

    Hi guys, i need a VBA code to lookup for Saturday and Sunday rows, and values from that rows add to Friday values. After that, replace Saturday and Sunday values with zeroes. But if Saturday or Sunday are first days in a month, add those values to Monday. Is that possible? File included...
  3. F

    Break links - sheets with charts

    It works well, thank you very much.
  4. F

    Break links - sheets with charts

    Hi guys, i need to break all links in worksheet, but problem is that some of the sheets contains charts, so normal codes to break links dont work. Is it posibble to break all links both on standard sheets and chart sheets by one code? Thanks.
  5. F

    Delete first five cells in a row based on two conditions

    Both codes works well, but way to slow on that large database. Thanks anyway.
  6. F

    Delete first five cells in a row based on two conditions

    My mistake, B contains value higher than 15 is right. (no 14, yes 16) Both are numbers.
  7. F

    Delete first five cells in a row based on two conditions

    Every week i get database, and i need to delete every record that is not 2016 in clolumn A and from 1 to 15 in column B. But only columns Axxx:Exxx bacause in further columns i have formulas. Q1: I want to delete cells and data from below move up. Q2: I need to do that as many times as both...
  8. F

    Delete first five cells in a row based on two conditions

    Hello, i need to delete first five cells (A:E) in a row in case that cell in column A contains value higher than 2016 and cell in column B contains value higher than 15. Both conditions must be true to delete part of that row. Is that possible? Thanks.
  9. F

    Group/ungroup selection in one macro

    It works well, thank you.
  10. F

    Group/ungroup selection in one macro

    Hello, i need VBA to recognise wether selection is grouped and in that case ungroup it, or recognise wheter selection is ungrouped and in that case group it. In one VBA code. With group i mean Data>Group/Ungroup function. Is that possible? Thanks.
  11. F

    Delete all rows above the cell that contain specific string

    Hello, i need a vba code that will delete all rows above the cell that contains specific string, is that possible? I got this one, but it will only delete two rows above. Dim x For x = Cells(Rows.Count, ActiveCell.Column).End(xlUp).Row To ActiveCell.Row Step -1 If Cells(x, 1) = "Slovakia"...
  12. F

    If value higher than x, clear content

    I see, thank you very much.
  13. F

    If value higher than x, clear content

    It will clear content just in column C, not in A:D.
  14. F

    If value higher than x, clear content

    But i dont want to clear content in entire row, but just in columns A:D.
  15. F

    If value higher than x, clear content

    Hi, i need to modificate the VBA code below to just clear content in colums A:D, not to delete entire row. Is that possible? Dim i As Long For i = Range("C" & Rows.Count).End(xlUp).Row To 1 Step -1 If (Range("C" & i).Value <= 2016) Then Range("C" & i).EntireRow.delete End If Next i...
  16. F

    Select used range just in one column

    I see, thank you.
  17. F

    Select used range just in one column

    Hi guys, i wanted to ask whether is it possible to select used range just in one specific column? I am alerady using code below to select whole used range, but i need to do that just in one column. ActiveSheet.UsedRange.Copy Thanks.
  18. F

    Open attachment of email

    I tried to run that macro at my work, and it says "Compile error: User-defined type not defined" with marked first line of the code. Do you know why is that? To my second question - I am getting emails with attachmens every day, and i want to save attachments only from emails received today. Is...
  19. F

    Selected cells multiply by 1

    Hi, i need code to multiply all selected cells by number one? Is it possible? Thanks. T.
  20. F

    Open attachment of email

    Thank you very much, it works really well. And what if i wanted to save attachments only from e-mails recieved that day? Is it possible? T.
  21. F

    Open attachment of email

    And would you share that code please? I didnt find it here.
  22. F

    Open attachment of email

    Hi, is it possible to open Excel workbook which is attached to recieved email in Outlook, copy data from that workbook and paste them into another workbook by VBA? Thanks for any advice. T.
  23. F

    Sum every nth column in sp

    Thank you.
  24. F

    Sum every nth column in sp

    Here it is, i need to sum all Zaplaceno columns (Zaplaceno 1, Zaplaceno 2, Zaplaceno 3...), but only in row with date 31.5.2015 for example.
  25. F

    Sum every nth column in sp

    Hi guys, i need to sum every eight column in variable row number. For example i need to sum every eight column in row 29. The number of row must be used in the formula. Could somebody help me with this formula? Thanks
Back
Top