Search:

Type: Posts; User: Michael M; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.50 seconds.

  1. Replies
    1
    Views
    41

    Re: speed up code?

    I haven't looked through the code, but try UNTESTED
    AND
    can you combine the Ucase statements ??
    Is row 8000 the true end of the data or did you just plug in an arbitary number ??
    What does this...
  2. Re: Cell format not getting changed as per original text

    You would need to post a small sample for us to look at, but how important is it....could you not simply make them all Capitals or small ??
  3. Re: Cell format not getting changed as per original text

    In that case higlight the cells in question
    Rclick>>Format Cells>>Custom>>in the Type box, put "mmmmyy" without the quotes
  4. Re: Cell format not getting changed as per original text

    Have you formatted the aliases column as Text ?
    AND do it before you put the new data in, if you can !
  5. Replies
    8
    Views
    98

    re: Calculate specific column with VBA

    The error is because you can't have 2 seperate worksheet_change events.
    You will either need to merge the events OR remove one of them
  6. Replies
    8
    Views
    98

    re: Calculate specific column with VBA

    If it's directly connected, could you not use a formula for each row ??
    Without knowing what calculation is required, a macro would seem like overkill !
  7. Replies
    6
    Views
    162

    Re: Distance between addresses

    It's only a link to another MrExcel thread, shouldn't get a 404


    https://www.mrexcel.com/forum/excel-questions/587230-excel-calculate-distance-miles-between-post-codes.html
    Maybe the full...
  8. Replies
    11
    Views
    176

    Re: IF condition problem

    what if one of the other conditions have been met.....I52 might be less than 50, but if C, E,G or K are true then it will give pass !
  9. Replies
    6
    Views
    162

    Re: Distance between addresses

    Been tried before....Have a look here....
    https://www.mrexcel.com/forum/excel-questions/587230-excel-calculate-distance-miles-between-post-codes.html
  10. Replies
    11
    Views
    176

    Re: IF condition problem

    Maybe this


    =IF(OR(C52>10,E52>15,G52>20,I52>50,K52>100),"Pass","Fail")
  11. Replies
    4
    Views
    91

    Re: Range Error in VBA Code Please help

    Try changing your Dim Statements


    Dim i, x, y, z As Long
    Dim R1, R12 As Range

    to


    Dim i as long, x as long, y as long, z As Long
  12. Re: Modify code so that formulas in table rows are not deleted

    So you don't want to delete the row, you just want to clear all contents, EXCEPT formulas ??
    Which columns in the row contain formulas ??
  13. Re: Vba loading slow while using for loop & if condition

    you haven't determined what LR and LastRow are..usually done by
    But why do you need and "x" AND a "y"

    In your code y could be replaced by x+1 in the equation

    Dim LastRow As Long, LR As Long...
  14. Re: Can I use macros to populate a new worksheet with rows from a table?

    We can't see a file on your computer !!
    You need to upload the dropbox or similar and post a link back here for us to see it.
  15. Replies
    1
    Views
    96

    Re: Flashing Columns

    you do realise that this will impact on the perfomance of your worksheet....and you will be unable to do other work on that worksheet while cell is flashing.
    AND
    It will drive any other user crazy...
  16. Re: Knowing the time it takes for code to run

    You could comment out all the lines that aren't relevent !
    OR
    You could apply a timer before and after the line you think is causing issues.
    What seems to be the issue ?
    How long is your code...
  17. Re: How to define this workbook and active workbook

    Unless, of course you need....

    dim Wb as workbook
    Set Wb=Thisworkbook
    OR
    Set Wb=activeworkbook
  18. Re: How to define this workbook and active workbook

    In that case you need to explain to us what you actually want to know !
  19. Re: How to define this workbook and active workbook

    Does this thread help ???

    https://www.mrexcel.com/forum/excel-questions/985315-thisworkbook-vs-activeworkbook.html
  20. Replies
    3
    Views
    84

    Re: Improve Calculation Speed

    These posts are pretty fast though...:lol:
  21. Re: Exit Function inside With-End With block

    Maybe make sure before you exit, you re-enabled anything that may have been turned off, like
    Screenupdating
    displayalerts
    enableevents
    calculation......etc
    that would normally be re-enabled at...
  22. Re: Exit Function inside With-End With block

    Can't see why not.....but you didn't ell us much either !
  23. Replies
    17
    Views
    276

    Re: Error: Cannot Shift Items off Sheet

    I don't believe there is a limit to the number of comments, but I'm guessing there would be a performance hit if you had a lot of them
    AND if they had a lot of info or graphics or pictures in each...
  24. Replies
    17
    Views
    276

    Re: Error: Cannot Shift Items off Sheet

    What I'm saying is:
    If you were to copy and ENTIRE row...then try to paste it anywhere in the same / other sheet, but in a different column, Excel would give that error, as an ENTIRE row MUST be...
  25. Replies
    17
    Views
    276

    Re: Error: Cannot Shift Items off Sheet

    Is this caused by a workbook_open macro ??
    It usually means sonething like you are copying a whole row and trying to paste it in col "B" or greater thereby trying to paste off the sheet
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4