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

  1. A

    writing macro that lives the formula inside the cell

    thanks. i wasnt so far. i just dont know to write the last formula with the "rc" operator. and the truth that i am still dont get the idea with this. its work perfect as i wish. thank you very much.
  2. A

    writing macro that lives the formula inside the cell

    hi there, i wrote a realy simple macro that multiply cells and lives a formula inside the cell. same row , different column. the life was too easy. but the real problem is that i need the macro to be dinamic. my meaning is: the macro needs to identify the number of the column by the column name...
  3. A

    error message

    hi, i have an error message in excell when i am trying to run a macro: "Excel ran out of resources.... how can i solve it. i have macros with loops on 5'000 lines. any Suggestions??
  4. A

    move filter sign from a pivot table

    hi, i have a pivot table that i want to ove into p.p. the problem is every column has a filter sign. how can i move the filter sign without lose the tital???
  5. A

    shortening if statement [SOLVED]

    lohith, your idea work very good. thanks to everybody...
  6. A

    shortening if statement [SOLVED]

    hi narayank the code you suggest make an error "type mismatch" on this line: x = Array(30, 36, 45, 50, 54, 63, 69, 91, 94, 133)
  7. A

    shortening if statement [SOLVED]

    my code runs with vlookup see below: Sub expances_sheet2() Dim cell As Range Dim i As Integer ' Workbooks(".xlsx").Sheets("").Activate Workbooks(".xlsm").Sheets("").Activate On Error Resume Next For i = 6 To 138 If Not i = 30 Then If Not i = 36 Then If Not i...
  8. A

    shortening if statement [SOLVED]

    hi, i have code with 'for' loop 6-138 i want the loop to ignore 10 numbers. i know that i can write if not statement to ignore one number. how can i ignore 10 numbers in one if statement? i attach part of the code to explain my question. the code runs on column with loop on the cells Sub...
  9. A

    code to verify if workbook is open

    hi, i upload the workbooks to rapidshare. https://www.rapidshare.com/#myrs_filemanager/file/0 notice that the two workbooksare empty i just want the macro to work. notce in my code that from workbook2 i search for if workbook1 is open. thanks again for your patience. asaf
  10. A

    code to verify if workbook is open

    yes i saved the files. where can i upload file?
  11. A

    code to verify if workbook is open

    hi probably i am doing something wrong the function is not working as well. i tried the function and procedure below like marc suggessted: Function IsOpen(Name$) As Boolean On Error Resume Next IsOpen = IsObject(Workbooks("workbook1 .xlsm")) End Function Sub find1() If IsOpen("workbook1...
  12. A

    code to verify if workbook is open

    hi again i tried this code again and its not finding the workbook name. for instance i created 2 workbooks: workbook1 and workbook2. then i try thi code below: Sub IsWorkbookOpen1() Dim wbName As String Dim wb As Workbook wbName = "worksheet1.xlsm" For Each wb In Workbooks...
  13. A

    code to verify if workbook is open

    question to vijay.vizzu its not working. can you check it. the fot each loop seems to be very simple but not work. thanks again...:)
  14. A

    code to verify if workbook is open

    hi, i have macro to open a workbook. i want to add single statement before to check if the workbook is already open please help.
  15. A

    simple vba code- active workbooks [SOLVED]

    THANKS' I MADE IT BY MY SELF.
See more
Back
Top