• 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. 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...
  2. 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??
  3. 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???
  4. 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...
  5. 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.
  6. A

    simple vba code- active workbooks [SOLVED]

    hi there i have a little problem i cant solve' i want to write a code that tells me what workbooks is active all the time. i succeed to write a code that tells me how many open but i cant get the file name. please help' asaf
  7. A

    simple problem with excell chart

    hi, i have a simple problem with excell chart.i have 2 charts' one for the sales and one for the budget. inside all chart i divided the parts into x,y,z. i need to merge this two chrts into one. it should look like every month i have the sales and the budget and must have divided inside to...
  8. A

    try findinding the catalog number from a cell with different numbers

    hi, I have a little problem, I have column with cataloged numbers like below: number + letters the problem is that the number in the cells can be 4 or 8 or 3... I cant use "right" formula. I need a formula that recognized how to look only for the numbers enclosed herewith file with...
  9. A

    create loop for main range

    hi, i wrote a simple code that suppose to run in main range, and inside this range i need the code to run column by culomn. the range is between column b to i, and i need to run first on column b after that to run on column c and ect... in every column thecode must manipulate the cells...
  10. A

    color cell under condition

    hi, i wrote a code to check cells in range. if the cells not match then color it in yellow. i need help just to ad to the code the order to color the code. here is the code: Sub checkcells() Dim cell As Range Dim x As Range For Each cell In Range("a1:a2") For Each x In Range("c1:c2") If...
  11. A

    build macros that checks the value inside the cell with other cell

    hi, i'm trying to define macro that check cell.value and compare it to other cell. i get an eror that object required/ please help... Sub checkcells() Dim cell As Range Dim x As Range For Each cell In Range("a1:a2") For Each x In Range("c1:c2") If cell.Value = x.Value Then MsgBox o.k...
  12. A

    power point to excell

    hi. i have a little problem with excell generating information into powerpoint. in my work i make presentation every sunday with almost the same details just replacing the name of the file.i want that after changing the file name to get inside powerpoint and change the direction. how can i do...
  13. A

    help with excell application

    hi there i have a little problem with sumif application/ when i run the macro below i get an eror that worksheetfunction does not work with sumif. i checked in vba help called worksheetfunction members and sum if was there. i dont understnd why its not working. please help Sub sumif1() Dim...
  14. A

    delete row enside a range under condition on a cell

    hi, i want to write cod that make 2 things: 1. running on a range and check the cell value (i know how to do it) 2. if the cell is 0 or a number i define' then delete the row. thanks for help its must be very simple asaf
  15. A

    help with excel transpose table

    hi there i want to transpose table (move axis x-becomes y and inversely) i know that i can do it with special paste, but i want it to be dinamic. I would appreciate your help in kind asaf
  16. A

    help in vba

    i have seen the lesson in utube called vba crash course. i copyied the module as is to visual basic. the problem is that i get an eror while trying to run the code. i add the code to the post with the debug line with three Asterisks. i wil be glad if u cuold help me solve this, i want to...
Back
Top