Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    oops wrong line as it was on
    Range(ActiveCell.Row + 1 & ":" & Cells.Rows.Count).Delete
  2. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    ok I went back and finally found where it stopped and that is on the
    Range(Cells(1, ActiveCell.Column + 1), Cells(Cells.Rows.Count, Cells.Columns.Count)).Delete
    not sure why but it does stop there...
  3. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    Damm I did get it to work as dumb as I am and it worked on all but two sheets and there it stopped on ?? well I lost it but it did get my file size down to 543 kb and I can live with that as it now...
  4. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    I am sorry but you have lost me as I am not sure what to put into the place of the xXXX
  5. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    there is only one array in the entire workbook the rest are just sum= or t= or reference to other sheets for the information it is quite simple I figured it should be about 100kb and the macros are...
  6. Replies
    9
    Views
    120

    Re: Excel is creating very large files

    yes that is what I have been doing but it doesnt seem to help
  7. Re: Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    no not really as it a much simpler workbook
  8. Excel has saved my file in size of 79.1MB or 81,147KB how do I reduce the size

    I just went from 2010 to 2016 and then to 2019. I have some programs that I created a few years back and they are all from 950kb to 1400kb and are all macro enabled worksheets. I just finished a...
  9. Replies
    9
    Views
    120

    Re: Excel is creating very large files

    I do have the macro working just exactly as you have shown but it still does not do the job but does execute very well
  10. Replies
    9
    Views
    120

    Re: Excel is creating very large files

    Sorry for not replying last night but had already gone to bed
  11. Replies
    9
    Views
    120

    Re: Excel is creating very large files

    I do have 14 sheets in this workbook and four of them when I do ctrl + end the cursor goes down almost 700 rows or to the bottom.
    I did try to use your code but either I do not understand how to use...
  12. Replies
    9
    Views
    120

    Excel is creating very large files

    I just went from 2010 to 2016 and have some programs that I created a few years back and they are all from 950kb to 1400kb and are all macro enabled worksheets. I just finished a new one in 2016...
  13. Re: find contents of one sheet and displaying on another based on contents

    you have made that so simple I am flabbergasted I have wasted over an hour trying to get that so I do thank you so very much for your reply and expertise.
    :)
  14. find contents of one sheet and displaying on another based on contents

    I am trying to retrieve contents of a cell in another sheet based on the contents of that sheets adjoining column as I want to find the data in sheet (ABC) based on the contents of sheet (ABC')...
  15. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    You Sir are my new hero as that does work for what I want and now to figure out how to get value in column A corresponding to the result :nya: and where to find the answer
    Thank you very much for...
  16. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    I am using Excel 2016
  17. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  18. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  19. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  20. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    sorry but approaching 80 I find I am not as sharp as I once was
  21. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    no my cells do have the =min(e5:I5) statement in them corresponding to that row and I have found that deleting all formulas in all blank cells it will work but will not if I have one cell with the...
  22. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    they all have the formula of =MIN(E20:I20) or a value corresponding to the row and I have found if I take the formula out of the blank cells it will work but will not work if I leave one cell with it
  23. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    the cells actually have the formula of =MIN(E99:I99) or corresponding to that particular row
  24. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    yes the cells are blank and after using =min(l5:l105) in cell l106 I just get a blank cell but the formula is still there
  25. Replies
    25
    Views
    2,017

    Re: Using MIN function in column with blanks

    Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have

    =MIN(E5:I5) and that works fine then at the bottom of column (L) I have another ...
Results 1 to 25 of 85
Page 1 of 4 1 2 3 4