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

    code to call a function

    i have written this code to code a function nameexists. I tried running it without success. Pls can the pro's help me look into it and make suggestions for ammendment. Dim address As Range, name As String Dim resp As String 'temp variable to hold input box variable; pass contents to...
  2. N

    Assigning values to an array

    Hi All, i have defined "address" as a range and i am trying to assign values to address and i am not getting succesful. below is my code For i = 2 To 14 address(i) = Range("A2:A14").Cells(i).Value VBA returns me an error "object variable or with block variable not set" I need some ideas...
  3. N

    What is wrong with this code

    Dear All, I have written the codes below, it returns text as result and keep running endlessly. What i am trying to do is to generate a lottery winning ticket and number. The comments ahead of each of my codes explains what i want to achieve there. I will appreciate if any expert in the house...
  4. N

    Problem with copying from a range

    Dear All, I wrote this code to copy contents of a range selection and paste it on another worksheet. The thing is that i want contents of only those rows withing the range that have values in their column C copied but my code copies everything. I am trying to resolve the problem of copying all...
  5. N

    Looping Through a range and Marching Data

    Dear All, I have a table that looks like the one i posted here. My aim is to pick information from the qty column and take their correspondent data and present them in a separate sheet as a summary report. What i have been able to do is to set each row range here to where i want them to...
  6. N

    Create separate summary sheets for each customer

    Thanks Luke, The article is indeed very helpful I have been able to create the summary sheets. I will see if i can conclude the project from here. Meanwhile i am a vba learner and will appreciate more online referneces to places where i can learn and master vba. I need real useful references...
  7. N

    Create separate summary sheets for each customer

    Hi Guys, Pls can anyone help with this.i need it seriously for a project.
  8. N

    Create separate summary sheets for each customer

    Hi All, I have a list of 30 products on sheet 1 cells A2:A31,their correspondent unit prices on cells B 2 to b31 and column C 2 TO 31 captures order quantity. The order taker inputs order quantities in sheet 1 column c. I need a code that once an order taker inputs an order quantity on...
  9. N

    VBA Worksheet Code

    Thank You Huys for the help. The code by Narayank Works. Please how do i exclude the original sheet 1 from being removed during the deleting. Thanks
  10. N

    VBA Worksheet Code

    Hi Luke, Thank you for the code. I have tried to run it. The delete aspect of it has a problem. It returns an error "method delete of object_worksheet failed" When i end debug and run it deletes the whole worksheets and leaves only one behind. Could the problem be because the worksheets are...
  11. N

    VBA Worksheet Code

    Hi Luke, Thank you for the code. I have tried to run it. The delete aspect of it has a problem. It returns an error "method delete of object_worksheet failed" When i end debug and run it deletes the whole worksheets and leaves only one behind. Could the problem be because the worksheets are...
  12. N

    VBA Worksheet Code

    Hi All,. I am a learner in VBA and i need help with the following VBA code I have an open workbook that contains 20 named worksheets.I have a list of 42 departments listed on range("A2:A43") in my sheet1. The 20 worksheets are named after the department list on sheet1.I am Looking for a VBA...
Back
Top