Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    265

    Sorry Zeddy my bad. I wish I had done this too...

    Sorry Zeddy my bad. I wish I had done this too b/c I spent the whole day cleaning this up manually and I only have one more file to do. Thank you never the less.
  2. Replies
    7
    Views
    265

    any help please?

    any help please?
  3. Replies
    7
    Views
    265

    Hello thank you for trying to help. However, when...

    Hello thank you for trying to help. However, when I ran the macro it did not do anything. Attached is a small sample. The red highlighted cells (which may vary) represents what I would like the macro...
  4. Replies
    7
    Views
    265

    anyone?

    anyone?
  5. Replies
    7
    Views
    265

    Excel macro to remove rows

    I need a macro that will find the All rows that BEGIN with the following text "Monthly Summary ***" and then delete all the rows in BETWEEN a row that begins with the text "Agent ****". I do not...
  6. My second quote was as it was you did not miss it.

    My second quote was as it was you did not miss it.
  7. Thanks Gary been to the sight before...I know how...

    Thanks Gary been to the sight before...I know how it works. IF you have a solution lmk.

    And don't be so uptight...you took my comment out of context.
  8. WHERE'S HANS?!?!?!!? (He'd have this solved...

    WHERE'S HANS?!?!?!!?

    (He'd have this solved by now).
  9. ok that's a start where would I find those shapes?

    ok that's a start where would I find those shapes?
  10. Anybody? please. Thanks

    Anybody? please. Thanks
  11. With PPPres.SlideMaster.Shapes("Rectangle...

    With PPPres.SlideMaster.Shapes("Rectangle 2").TextFrame.TextRange

    [attachment=91121:Doc1.docx]
  12. Hi my company recently upgraded us from 2003 to...

    Hi my company recently upgraded us from 2003 to 2010 Excel. Now as a result none of our macros work. Below is the Error and the entire. If someone could please explain why this is happening and what...
  13. Replies
    1
    Views
    459

    Hello I need a macro that will check a range of...

    Hello I need a macro that will check a range of cells for dependents (Trace Dependent Function). Lets say I6:I942 and if it's NOT dependent to anything then highlight the entire cell in RED. Thank...
  14. For example I want to use the same range name...

    For example I want to use the same range name "retrieve" for sheet1,sheet2,sheet3,sheet4,etc. For this example the cell range is A1:D50.

    Unfortunately everytime I try to do this it overwrites...
  15. Replies
    6
    Views
    2,189

    Re: Easy way to Trace Dependents? (Excel 2003)

    No that's the objective. I am trying to delete the select cells that are NOT linked to other sheets in the workbook but first I need to determine if they are dependent elsewhere in the workbook.
  16. Replies
    6
    Views
    2,189

    Easy way to Trace Dependents? (Excel 2003)

    I have a spread sheet with 10 columns and 1000 rows for a total of 10,000 cells. Of that 10,000 there are about 2000 cells randomly scattered that I would like to check for dependents and then delete...
  17. Replies
    6
    Views
    2,189

    Re: Esay way to Trace Dependents? (Excel 2003)

    Post deleted by aluislugo
  18. Replies
    6
    Views
    2,189

    Re: Esay way to Trace Dependents? (Excel 2003)

    anybody? please.
  19. Replies
    3
    Views
    670

    Re: links and chart problem (excel 2003)

    1. opened file B09 yoy walk.xls
    2. selected update
    3. recieved edit links message and selected
    4. received the following message under Status "warning open source to update values" (Error message)...
  20. Replies
    3
    Views
    670

    links and chart problem (excel 2003)

    Word attachment replaced with picture by HansV - saves a few clicks

    getting the following error and can't seem to update my charts. Thanks you in advance for your help.
  21. Replies
    3
    Views
    2,460

    Tracing a link? (Excel 2003)

    Anybody know how to trrace a link in a spreadsheet?( I am trying to find the linked cell/s). I have tried to switch to formula auditing mode and try to find it that way but no luck. And I just don't...
  22. Replies
    17
    Views
    3,429

    Re: Moving Monthly Formula (Excel 3.0)

    Point well taken my friend!

    Nevertheless thank you once again for all your help.

    Regards,
    aluislugo
  23. Replies
    17
    Views
    3,429

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans I did as you suggested but I still got errors in cells AC25,27,28 and AQ25,27,28 ?
  24. Replies
    17
    Views
    3,429

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans, once again it seemed to work for col AC, however for col AQ there were a few errors (see highlighted cells in yellow). I think that the formula in AQ needs to be modified slightly to add in...
  25. Replies
    17
    Views
    3,429

    Re: Moving Monthly Formula (Excel 3.0)

    Hans I was thinking why can't your original formula be revised with an AND statement i.e., IF(COUNTIF($B12:$M12,">0"(and(countif($b12:$m12,"<0")......etc.

    If so how would that formula look like? ...
Results 1 to 25 of 82
Page 1 of 4 1 2 3 4