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

Recent content by Cammandk

  1. C

    Loop through fixed number of rows

    Posted this by mistake in the excel formula forum. I do need a vba solution as in J9:J38 there is a data validation list that contains "Cash Withdrawal" as part of the list options I'm looking for code that will loop though O9:O38 and if on any of those rows the first 4 characters = "Cash"...
  2. C

    Loop through fixed number of rows

    I'm looking for code that will loop though O9:O38 and if on any of those rows the first 4 characters = "Cash" then "Cash Withdrawal" will be put in the adjacent J9:J38 cell. So if O15 = "Cash Deposit abcd " then "Cash Withdrawal" will be entered into J15 ▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as...
  3. C

    Formula gives circular error

    I have sales revenues which have a commission % deducted to leave an net amount that repays an investment. The total investment to be repaid is $5000. Until 50% of this is repaid ie $2500 the commission to be charged should be 5%. Once $2500 has been repaid any further sales amounts should have...
  4. C

    Code not saving to sharepoint

    Hi All I have the following code which creates a backup of the open workbook - this works when on a local machine. I now have the file on a sharepoint drive and it's not working. I've already changed the \ to / in the path's but still not registering. Is it do to with being a URL? Any help...
  5. C

    Filepath when Saving to Sharepoint folder

    I had code to correctly save to a local/network folder but its now not working when the file is on sharepoint. 'the following function will get the path only (i.e. the folder) from the file's full path: Function FilePath(strPath As String) As String FilePath = Left$(strPath...
  6. C

    Can this macro be speeded up

    Luke you are correct - I've amended to just work with the filter Hui - point noted. Thanks
  7. C

    Can this macro be speeded up

    I am using the code below to hide rows that are not relevant to print and/or copy just relevant data to another sheet. The code below looks at all the rows in Col A and if they =0 it hides the rows. This seems to be taking a lot longer than it initially did. It looks through approx. 2000 rows...
  8. C

    Select TimeValue from cell

    Hi Luke Once again thank you for solution - it's working nicely. I posted an earlier thread 25th May "Add new cell value to list in another sheet" Would you have any thoughts on this - if you can? DK
  9. C

    Select TimeValue from cell

    I have a cell that shows the minutes I require (although formatted hh:mm:ss - still seems to include date) Sheet6.Range("TimeInterval") How can I use this in the code below. dTime = Now + TimeValue("00:05:00") Thanks DK
See more
Back
Top