• 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. C

    Why when line gets inserted does it then get hidden

    I have the code below to insert lines on a sheet. It works correctly and inserts the lines BUT then the lines get hidden. I can't understand what is causing this. There is no event code in the worksheet module. DK. Sub InsertSch1NotesLine() Dim myRow As Long Application.ScreenUpdating =...
  2. C

    Go to selected sheet on open still flashes last sheet from close?

    Hi Luke, SirJB7 I think you are both right. Luke I've already gone your route and it's certainly better. The hardware maybe struggling as well - Vostro 3500 3gb ram. File is 5meg without data yet - about 60 sheets in. I'll try on a faster machine. Thanks DK
  3. C

    Go to selected sheet on open still flashes last sheet from close?

    Hi Luke Tried this already and it made no difference. It is definitely showing the last screen when the workbook closed - feels like for almost a couple of seconds. DK
  4. C

    Go to selected sheet on open still flashes last sheet from close?

    When the workbook opens I want it to go to the selected sheet which I am using as a splash screen based on a condition. I've put this code in "This Workbook" to action when WB opens. However it doesn't go cleanly to this screen. It still flashes up what I think was the last sheet when workbook...
  5. C

    Delete User selected rows only if Col B ="1"

    This did select and delete the lines after testing - but where is the condition that B = 1 (or even "0" in your notes) to allow row delete DK
  6. C

    Delete User selected rows only if Col B ="1"

    I've attached a sample section of a worksheet. I don't understand why there may be so many validations to check? Thanks DK
  7. C

    Delete User selected rows only if Col B ="1"

    I need a macro that will delete rows based on the below criteria: The user can select a cell on a row or rows that they want to delete (therefore maybe multiple and non continuous rows) The row can only be deleted if the value on the row in col B = "1". Need some error handling if any of the...
  8. C

    Sum cells only to a Maximum value

    I've added comments.
  9. C

    Sum cells only to a Maximum value

    Revised file with more explainations. Thanks D.
  10. C

    Sum cells only to a Maximum value

    Kyrre. Thanks for trying this is not what I need. I need the investment row to take what ever it can from the Sales Total value upto the max of 500 across the rows. I'm trying to recover the value up to 500 across the Sales columns
  11. C

    Sum cells only to a Maximum value

    I should know this but just can't get my head around. Any help would be appreciated. Attached file shows simple layout of whats needed.
  12. C

    Give array a Name and use in code

    Hi Luke Not sure if this is what I'm after - maybe I wasn't clear enough. On a Worksheet I want to have a list in A1:A3 - "Sheet1", "Sheet2", "Sheet3". I want to name this range "ArrayList" I then want to use this name "ArrayList" in the code to replace all the sheets as I may have 30 sheets...
  13. C

    Set Password using value of named range

    Hi Hui I had found a solution - 'Sheet28.Unprotect Password:=CStr(Sheets("CMSetup").Range("PWFloats").Value) Yours is much more elegant. Thanks [SOLVED]
  14. C

    Set Password using value of named range

    How can I use the value of a cell to be the password name in my code. If the value in A1 is "Password" and this is named as "PW1" how can this be placed in the code Sheet1.Protect Password = "PW1" Thank DK
  15. C

    Give array a Name and use in code

    I have the following line of code that selects the 2 sheets. [For Each sh In Sheets(Array("Sch6", "Sch7"))] Can I create a list of sheets and name this range and then just have the one name in the above formula. Thanks DK
  16. C

    Match data on source and destination sheet and change value

    I have extracted data from multiple sheets and now want to mark this data as "Paid" and for the macro to go back and change the value in the original sheet on a row in column "AR" to "PAID. All the columns have the same data type in. The extracted data contains the original sheet name and each...
  17. C

    Code to Loop down Column and copy range to another worksheet

    Hi Smallman Can you help me with the reverse of what you provided: I've outlined in the attached worksheet. Thanks DK
  18. C

    Code to Loop down Column and copy range to another worksheet

    Hi Smallman Thanks for getting back. The code is working really well and I've been able to adapt it do other things in my workbook. One further request - is it possible to have 2 criteria for the autofilter - like "F" and "A". I've tried to get to work but obviously either not possible or I'm...
  19. C

    Code to Loop down Column and copy range to another worksheet

    Finally figured this out. lr should be lw lw = Range("A" & Rows.Count).End(xlUp).Row should be lw = sh.Range("A" & Rows.Count).End(xlUp).Row
  20. C

    Code to Loop down Column and copy range to another worksheet

    Can't get new code to work. Does "lr" need to be defined as new variable or should this have been "lw". Tried as "lw" but doesn't pull across any data. Then with the "lw" changed >1 to >0 - this pulled across records but when a sheet had not matching criteria it goes back to original issue of...
  21. C

    Code to Loop down Column and copy range to another worksheet

    Have tried and it does now work. However if a sheet does not contain the "Criteria" value it pulls in the header line into Sheet5 Thanks DK
  22. C

    Code to Loop down Column and copy range to another worksheet

    Hi Smallman Demo file attached - Sheet 1 & 3 have non consecutive rows. Sheet 4 all consecutive. When macro runs on Sheet5 it brings 1st matching row from Sheet 1 & Sheet 3 and all matching rows from Sheet4. The criteria in "D" could be on any consecutive or non consecutive rows in "D". I've...
  23. C

    Code to Loop down Column and copy range to another worksheet

    Thank you for you reply. As a newbie to this it's hard to always understand how specific the question/criteria needs to be - so apologies if the goalposts keep moving. When you refer to give out the co-ordinates for a non consecutive range - what do you mean. The values in my criteria column...
  24. C

    Code to Loop down Column and copy range to another worksheet

    I've got this working now - where the data is in consecutive rows - but on my sheets it won't be - when i tried this it only brings across the 1st date row from each sheet and then stops. Is this possible to address. thanks DK
  25. C

    Code to Loop down Column and copy range to another worksheet

    Smallman Thanks for this - trying to adapt - where within the code are Columns A to G selected? Thanks DK
Back
Top