Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds; generated 23 minute(s) ago.

  1. Replies
    4
    Views
    104

    Re: Check status of current filter mode

    Does this help you...



    Sub GetFilters()

    Dim ws As Worksheet: Set ws = ActiveSheet
    Dim filt As Filter
    Dim ct As Long
    Dim fs As String
  2. Re: Moving a Row with a negative value to another sheet

    Hi Peterlightingdept,

    Welcome to the MrExcel forum. This can easily be done but a little more information would help the process. Things like what column holds the number that turns negative, what...
  3. Re: Convert SSN in one column to text in the adjacent column

    Duplicate Post:

    https://www.mrexcel.com/forum/excel-questions/1114256-convert-ssn-one-column-text-adjacent-column.html#post5367105
  4. Re: Formula to identify and display all numbers from 2 separate cells

    I am not sure I understand (I got lost somewhere, data string??). You want to combine all the zips in the Column G's from separate sheets and put them all in one column. What sheet would this long...
  5. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    A) I probably should have been more clear, B) I could have just done this myself before I asked my question, but I was running out and asking was just easier...

    I took a cell and formatted the...
  6. Replies
    11
    Views
    292

    Re: Help with Offset after loop

    Great! I am happy I was able to help you. Thanks for the feedback.
  7. Replies
    11
    Views
    292

    Re: Help with Offset after loop

    Does this do what you want...


    Sub movevalues2()

    Dim rngRx As Range, rngKQ As Range
    Dim i As Long

    Set rngRx = Range("R5:X7000")
    Set rngKQ = Range("K5:Q7000")
  8. Replies
    11
    Views
    292

    Re: Help with Offset after loop

    Can you show a small sample of the before and after that you expect....

    Do you want the cells that contain formulas to be copied back as blank cells with no formula. If that is the case, how about...
  9. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Hi Peter, may I ask you one more question...

    Does the above mean that a given cell could have two different simultaneous colors that could be used to address that cell.
  10. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Just the fact that you thought of interrogating each cell is what I was trying to convey. It never would have occurred to me that the manner which the cells colored would lead to a faster way to get...
  11. Re: Formula to identify and display all numbers from 2 separate cells

    I am glad that it works for you, I was happy to help. Thanks for your feedback!!
  12. Re: Keyboard Shortcut to View all Worksheets (Excel 2010)

    Wow Fluff, I can now say that I honestly learned something today.
  13. Re: Keyboard Shortcut to View all Worksheets (Excel 2010)

    Ctrl+Page Up/Down: Move to the previous or next worksheet
  14. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Yes, clearly your approach was much quicker than mine, which clearly shows the difference between my immature coding skills compared to your more mature skills.

    Thanks again for taking the time to...
  15. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Thank you very much.

    Here are my timing results taken from your Status tab...


    <colgroup><col span="3"><col></colgroup><tbody>
    John_w


    2.109 secs
  16. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Thanks for this. I will try to duplicate your work. Any chance of throwing your workbook up to a site like dropbox or something similar. That would only be easier for me and not for you. LOL.
  17. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    My timings comparison are not correct as you ran my code on your data with your machine. Sorry about my idiocy, I obviously need another Vodka!

    I am still curious though, about the difference in...
  18. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Peter_SSs


    Perhaps you did not see on my post 19 that I ran my code on 10K rows of data. If I cut that range back down to 2k of data, then my code runs in 0.1094 seconds. A barely perceptible...
  19. Replies
    11
    Views
    292

    Re: Help with Offset after loop

    I am a little confused with exactly how you want to deal with the non blank cells. if a cell is blank and you want it to go away then any cells to the right of the blank are going to move more than 7...
  20. Re: Formula to identify and display all numbers from 2 separate cells

    I sometimes find it is easier to do stuff with a macro rather than a formula. I guess if I had better formula skills that would be different. I also think I read somewhere that if a task can be...
  21. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Something does not sound right. There has to be something going on for this small piece of code to take a minute to execute. Is it just this one task that takes long or do you notice sluggishness on...
  22. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Do you have a lot of other stuff going on with that machine. I only ask because on my stand alone computer, my test data which uses the range C2:Z10000, the code executes in less than second.
  23. Replies
    41
    Views
    1,153

    Re: Faster way to loop

    Out of curiosity, about how long does it take for whatever macro you are using now to complete. Is it minutes or seconds...
  24. Re: Formula to identify and display all numbers from 2 separate cells

    Are the numbers that you are looking for that fall in between the low and the high zip codes, just adding 1 to the lower number until you reach the higher number or are the coming from a list of...
  25. Replies
    2
    Views
    123

    Re: PTO Accrual Formula

    Wouldn't a better approach be, to take Jane's PTO accrual rate per pay period, determine the the number of full pay and fractional pay periods that fall between the employment start date and the...
Results 1 to 25 of 149
Page 1 of 6 1 2 3 4