Search:

Type: Posts; User: riteshjadwani; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    382

    Is there anyway to lock the embadded document in...

    Is there anyway to lock the embadded document in Excel sheet so that is it read only? When I protect the sheet with Edit Objects option unchecked it locks the object but also does not allow to read...
  2. Replies
    5
    Views
    726

    Hello Everyone, I am looking for a method to...

    Hello Everyone,

    I am looking for a method to pick the second latest copy item from clipboard for pasting at desired location.
    We have designed a workbook which keeps track of the navigation...
  3. Replies
    2
    Views
    371

    Thanks Hans, I think this will work.

    Thanks Hans, I think this will work.
  4. Replies
    2
    Views
    371

    My team is involved in Senior level management...

    My team is involved in Senior level management reporting about the status of different projects running within the group. We compile data for 40 Projects in an excel file. The data represented is...
  5. Replies
    2
    Views
    813

    Duration Calculation (MSP 2003)

    Hi
    I have a very basic question. My Project has 8 hours per day. (Hours Per Day Setting) Resource A works for 9 hours per day and Resource B works for 8 hours per day.(I Set up the Resource...
  6. Re: Conditional Formatting (Excel 2003 / VBA)

    Actually, its a big worksheet with multiple parameters. Its something like a balance scorecard. There are different parameters with different threshold values for doing the color scheme in terms of...
  7. Re: Conditional Formatting (Excel 2003 / VBA)

    Hi

    There is some issue I am facing. My conditional formatting is based on values in other cells. Due to this the macro does not update the color index value. If I base my conditional formatting...
  8. Re: Conditional Formatting (Excel 2003 / VBA)

    Thanks , I got the solution from this site.
  9. Conditional Formatting (Excel 2003 / VBA)

    Hi

    I am trying to write a macro. My objective is to read the color index of a cell and then based on the color index perform some mathematical operations. The color of the cell is based on...
  10. Re: Read contents wihout opening (Excel 2003 / VBA)

    Thanks. It works.
  11. Read contents wihout opening (Excel 2003 / VBA)

    Hi,
    I need to send excel files to my team members in which they are supposed to send their weekly reports. I save all the files that I send them in a particular directory (sent). Once the team...
  12. Replies
    2
    Views
    8,974

    Re: Search Text in a Single Cell (VBA)

    Thanks Hans. I worked on it today and it works like a beauty.
  13. Replies
    2
    Views
    8,974

    Search Text in a Single Cell (VBA)

    Hi,
    I have an excel requirement. I am trying to write a macro, that would check the occurences of specific text within a single cell. If the text is found in that particular cell, then some more...
  14. Replies
    16
    Views
    983

    Re: Error Handler (VBA )

    Thanks All.. I will try and see which one suits the best
  15. Replies
    16
    Views
    983

    Re: Error Handler (VBA )

    Hi

    I do not directly resume after handling. On receiving the error, the control shifts to the error handling statement and executes the code written therein.
  16. Replies
    16
    Views
    983

    Error Handler (VBA )

    Hi,

    In an excel Workbook, I am trying to insert two sheets - SV, EV. If these do not exist, then error handling is required I am trying to put two error handling conditions in my code as different...
  17. Replies
    5
    Views
    1,043

    Re: Auto Correct (Excel 2003)

    Hi

    One more question. Is it possible to share names across different workbooks?
  18. Replies
    5
    Views
    1,043

    Re: Auto Correct (Excel 2003)

    Thanks Hans. It works!
  19. Replies
    5
    Views
    1,043

    Auto Correct (Excel 2003)

    Hi,
    I need to type some text again and again. Most part of this text remains the same, except that cell references keep changing. So I used auto correct formula like this:
    Replace : ch
    With: ...
  20. Re: Using Variables across MSP, Excel in VBA (MSP 2003)

    Hi

    I got the solution. The first error was that wk1 needs to be declared as variant and second one that Row no. cannot start with 0.

    Thanks for your interest in solving this.
  21. Re: Using Variables across MSP, Excel in VBA (MSP 2003)

    Hi,

    I delcared - Public wk1 As Date and Public wdth As Integer
    The value I am getting for wk1 (in one such case) is 6/2/2006 and wdth as 5
  22. Using Variables across MSP, Excel in VBA (MSP 2003)

    Hi,
    I am writing a program in which first a user inputs a week starting date and based on some calculations the no. of weeks in the month are calculated (either 4 or 5) . I have declared public...
  23. Countif on Multiple Worksheets (Excel 2000)

    Hi
    I have a workbook containing multiple worksheets. These worksheets contain information about many projects that run in my organization. These sheets are arranged in the names of individuals...
  24. Replies
    4
    Views
    578

    Re: sumproduct (Excel 2000)

    Hi

    Reply given by Legare Coleman is exactly what I am looking for:
    =SUMPRODUCT((A1:A9=1)*1,B1:B9,C1:C9) -- That formula will sum the product of B1:B9 and C1:C9 if the
    corresponding cell in...
  25. Replies
    4
    Views
    578

    sumproduct (Excel 2000)

    Hi,

    Is there any way by which I can do a sumproduct formula based on a "if" condition. What I am looking for is something similar to sumif except that it should be sumproduct function.
Results 1 to 25 of 32
Page 1 of 2 1 2