Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: problem with exiting loop after 'If Then Else' procedure is executed...

    I swear I had tried just this when I was trying to get it to work before I gave up and posted for help! lol When i saw what you posted, I said to myself "nope, already tried that! its not going to...
  2. Re: problem with exiting loop after 'If Then Else' procedure is executed...

    Thanks, but this still keeps it in that annoying loop. :confused:
  3. Re: problem with exiting loop after 'If Then Else' procedure is executed...

    PSS- I tried multiple different ways of using ElseIf but I could't get it working at all no matter how I had the code written.
  4. problem with exiting loop after 'If Then Else' procedure is executed...

    Dim iP As Variant
    Dim cntRows As Long
    cntRows = ActiveWorkbook.Worksheets("ANALYTICS").Range("F65536").End(xlUp).Row

    For Each iP In Range(Cells(1, 6), Cells(cntRows, 16))
    If cntRows <= 15...
  5. Re: what is wrong with this single line of code (finding last row in a column)

    That's it. Thank you. & FWIW I dont have any blanks. Column E does have blanks in it, but the procedure right before this one, I had it copy just the cells with content from column E and paste...
  6. Re: what is wrong with this single line of code (finding last row in a column)

    Thank you, Fluff.

    How would I go about searching starting from F1 and down to the last cell? (the 2nd code sykes provided works fine, but I would like to understand how to locate the last row...
  7. Re: what is wrong with this single line of code (finding last row in a column)

    Thank you, the second one worked for what I need.

    Coincidentally, the first code returns a value of "1" (when I use MsgBox to show me the value of the variable) when there was actually 23 rows in...
  8. what is wrong with this single line of code (finding last row in a column)

    Dim cntRows As Long
    cntRows = ActiveWorkbook.Worksheets("ANALYTICS").Cells("F1").Find("*", , , , xlByRows, xlPrevious, , , False).Row


    Trying to find the last row in Column F that is not blank. ...
  9. Re: help with code that will copy range from one worksheet and pastes it to another... but with a 'twist'

    Here is my current existing code that tallies the number of each of those variables (which in turn they actually came from what checkbox was previsouly ticked on a userform)



    qRow =...
  10. Code that will copy range from one worksheet and pastes it to another... but with a 'twist'

    I need my code to copy a range (which is a single column) from one worksheet, and then paste it to another worksheet, but when and if the number of rows that is being copied is more than 15 rows, it...
  11. Re: count number of times that a specific string occurs inside a range of cells

    never mind... I got it figured out :)



    Dim cP As Range
    Dim aRow As Long
    Dim mis4d As String

    mis4d = 0
    aRow = Cells.Find("*", , , , xlByColumns, xlPrevious, , , False).Row
  12. count number of times that a specific string occurs inside a range of cells

    I need to get the VBA code where it looks in column P, starting at Row 4 and down... AND only looks at only the visible rows in order to get a count for each string that it is looking for

    Column P...
  13. Re: finding last row (that is visible) starting from the first row (that is visible)...

    Thank you, Fluff. You must of replied right before I edited my post.. . Thank you again :beerchug:
  14. finding last row (that is visible) starting from the first row (that is visible)...

    never mind... I got it! apologies for the 'false alarm' ;)

    how do I find the last visible row when starting from the first visible row, but BELOW a certain starting point?

    So in the example...
  15. Re: help with this code for assigning a value to a cell when another cell contains a specific string value

    awesome. many thanks, Fluff. https://www.mrexcel.com/forum/images/icons/icon14.png
  16. help with this code for assigning a value to a cell when another cell contains a specific string value

    Column P (16) contains 'codes' that represent a description of something. Example: "CSR2B" = wrong labels

    Also there can be more than 1 code in each cell in column P (and almost always will be...
  17. how should this line of code be written/structured?

    PURPOSE:
    If a specfic checkbox on a userform is checked, then it needs to look in a specific cell for a specific string on a worksheet and if found, then that row is to remain visible, and if not...
  18. Re: cannot get focus to direct to a specific worksheet uploading userform

    I changed how the form is called upon (activated) from the action of clicking on a sheet tab ("Get Report") to a command button that I put on the worksheet itself ("Seatex Incident Log".) After I...
  19. re: cannot get focus to direct to a specific worksheet uploading userform

    Added it just like you have prepared for me (thank you, btw) but it still directs it to the main (Seatex Incident Log) worksheet. Any other suggestions?
  20. re: cannot get focus to direct to a specific worksheet uploading userform

    Thank you for your suggestion, Jaafar.

    I did try that, putting the:



    ActiveWorkbook.Worksheets("REPORTS").Activate
    ActiveWorkbook.Worksheets("REPORTS").Visible = True...
  21. cannot get focus to direct to a specific worksheet uploading userform

    * thats supposed to be 'after UNLOADING userform'... (not 'uploading') sorry, my bad.

    when the form is opened, it asks for a date range. when a commandbutton is selected, it gets the data from...
  22. Re: selecting a date range from userform and sorting the range on worksheet

    THanks, Dave. THat code worked for me!!


    the date picker I am using isnt the DTPicker but another one that I found on here (mrexcel)that I was able to implement into my workbook so that other...
  23. selecting a date range from userform and sorting the range on worksheet

    I have 2 txt boxes on a form which are datepickers. txtDateBox2 is for entering the start date, and txtDateBox3 is for enterning the ending date.

    When cmdGetReport button is selected I need the...
  24. Code that selects data between a certain (specified) date range

    I am creating a userform that will allow the user to select a specific date range, and then when the command button is selected, it will sort data on the worksheet that falls between the 2 dates.
    ...
  25. Re: help with 'advance to next record' code for button on userform

    Great information, thank you Dave.

    And the code worked great. No changes necessary at all.... right out of the box & worked on the fisrt try!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4