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

    Dates filter not working in VBA

    Thank you, both recommendations work...
  2. C

    Dates filter not working in VBA

    Thank you, your recommendation works..
  3. C

    Dates filter not working in VBA

    Hello ALL, I have a macro that filters dates by month and year based on cell values. I have dates that range from the year 2020 till year 2030. Now the strange part is that all years filter properly except for any dates that lie within the year 2030 I have the below code and could'nt find a...
  4. C

    Run time error '91' object variable or with block variable not set error on opening file

    Hi, Your recommendation to remove the worksheetfunction works fine, I used application and now it dosen't throw an error. Many thanks, learnt a lesson here.:)
  5. C

    Run time error '91' object variable or with block variable not set error on opening file

    Hi, thanks for replying, I removed the worksheetfunction as Marc L explained and now when I download it and enable editing it works fine. Thank you,
  6. C

    Run time error '91' object variable or with block variable not set error on opening file

    Hi All, I made a macro file with a worksheet selection change events, whenever i send it to my colleagues over the internet by mail, when they open it, they have to enable editing, after enabling editing it throws this run time error '91' object variable or with block variable not set , once...
  7. C

    Mouse events on charts

    Hi Chandoo, Is it possible you could do some tutorials on mouse hover events on charts.... thanks, Mustafa
  8. C

    Dashboards

    Hi there, I have an excel dashboard and a combo box that select the users name, below are some charts that update accordingly. I dont want the end user to mess around with the charts so i need to lock all the cells and charts in the dashboard. If i lock all the cells, and hover my mouse over...
  9. C

    Pricechecker

    Thanks so much.....Luke......that makes my life a little easier..... Mustafa
  10. C

    Pricechecker

    Hi Luke, It worked...thanks so much...if you dont mind can you explain this code: Range(Cells(i, "C"), .Offset(0, 1 + .Value)).Value = _ .Value * .Offset(0, 1).Value im a beginner, so i need to understand and practise this myself...... Thanks so much....why does VBA seem so difficult...
  11. C

    Pricechecker

    Hi all there , can you help with some VBA code for the following: In column A i have some numbers between 1 and 12 which represents units, and column B has the price. In column C-N which starts from January i need to have the result of units * price but the cells should be filled in such a...
  12. C

    Nesting formulas

    Hi Chandoo / Everyone How can we learn how to nest formulas and make really mega formulas. If you can share some data with nested formulas with the explanations, would be great. Thanks, Mustafa
  13. C

    ANIMATED CHARTS

    HELLO EVERYONE OUT THERE, CAN ANYONE COME UP WITH AN ANIMATED CHART, SOMETHING THAT MOVES SMOOTHLY....IF YOU HAVE SEEN THE EXCEL HERO WEB SITE....CAN ANYONE EXPLAIN HOW THAT IS DONE...OR BETTER CAN ANYONE SUGGEST AN EASIER METHOD HOW TO DO ANIMATION IN CHARTS. CHANDOO...WOULD LIKE YOUR HELP IN...
Back
Top