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

    Sort when deactivating or leaving the sheet

    Dear All I have two sheets; Names and Data. The Data sheet is entered with inputs, but the Name field comes from using dropdown validation of NameListRng that comes from the Names sheet. Now as the Names are added in the last row in the Names sheet it needs to be sorted when i move back and...
  2. K

    Insert entirerow improvement needed [SOLVED]

    Many thks, Deb. It makes sense Rgds KN
  3. K

    Insert entirerow improvement needed [SOLVED]

    Hi Deb My mistake the sub should read InsertLine. The code works. What i am asking for is improving the coding there is too much duplication as in: Range("InsertRow").Select ActiveCell.Offset(-1, 0).EntireRow.Select Selection.Copy Selection.insert shift:=xlDown Can i not avoid select...
  4. K

    Insert entirerow improvement needed [SOLVED]

    Hi Deb I have name range "InsertRow" which is attached to a button. This will insert a row above the name range and clear the specified cell contents. My mistake the "lrnInsertCurr should have read "insertRow". Its working the way it is. I just thought there may be a better way or improvement...
  5. K

    Insert entirerow improvement needed [SOLVED]

    Hi I hope someone can help me with improving the following code: Explaination would be most helpful. Rgds Kieranz Sub InsertRow() Dim sClrC As String, iActvC As Integer sClrC = "D1:J1,L1,N1:O1,U1" iActvC = Range("lrnInsertCurr").Column Range("InsertRow").Select ActiveCell.Offset(-1...
  6. K

    Rank on Two Criteria

    Hui and Narayan Most grateful. Thank you KN
  7. K

    Rank on Two Criteria

    Hi All We are doing a fun raising “Bicycle Race”! We would like to have a leaderboard to display bikers timetaken. So for purpose of example I have biker name Column; Stage Completed Column and TimeTaken column. Data is as follows: Aaa 4 5:00 Bbb 3 4.40...
Back
Top