1. G

    Finding each cell where a style is used

    Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith
  2. A

    Finding the text and moving Next cell

    Hi All, Thank for your support for learning for VBA I have a small problem, I find the text and copy 7 cell in the Active sheet but code not move Next finding. This my code Cells.Find(What:="Date", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows...
  3. J

    Finding Date in Listview

    Hi, Is there anyone that can show me how to find in listview control column 2 the earliest date and populate it in textbox 1, and the latest date into textbox 2. Thank you to anyone that can help me.
  4. D

    Finding value of last cell in list

    I need to find the value of the last number in column A and add 1 to it. Can someone help me with the vba for this please? Thanks, Dave
  5. F

    last used row in column C equals last used row in column E

    Hello everyone, I could use some help in finding last used rows. If C1 is >0, I need the last used row in column C to equal last used row in column E. thanks
  6. L

    finding the second match if the first value is equals to zero

    how to get the second value if the first value is equals to zero across multiple sheets?
  7. K

    IFs, ANDs, and BUTs

    Need help finding a formula for the following conditions: If AV14="Yes" AND AV76 is a number, then enter the value of AV76, BUT if AV14="No" then enter "N/A". Any help would be appreciated. Thank you!
  8. K

    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 below, the code would need to locate the first visible row that is below row 3, and down to the last...
  9. K

    Finding and getting text from a lot of cells in a row

    Hi, I am trying to find a text in a row, A9:AP9 where this value is: id: "bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b" I then want to take the value between the " (speech marks) and return it to another cell, so I would have bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b Is this possible? I have tried all...
  10. C

    how to quickly fill in a table

    I have an Excel table of that format number | description | weight 1 | weight 2 | number | description | weight 1 | weight 2 I have to fill in data by finding the number and manually fill in weight1 and weight2 Is there a way I could just make the data entry quickly instead of finding...
  11. R

    VBA Finding keywords then copying nearby rows of variable length

    Hi, thanks in advance for any help, I realize it's a lot. I'm trying to take one sheet and upload data to another. The task is: 1) Find Keyword 1 on Sheet 1 2) Skip 3 columns and copy a varying number (based on source sheet) of columns with data; below would be 4 columns (111 thru 114) but it...
  12. S

    Look up a value and display the score

    hi am finding it hard to explain it but it should be easy in the example <tbody> A B C D E F G 1 Score Level Score Level 2 10 AA 10 =????? 3 20 BB 15 AA 4 50 CC 18 AA 5 100 DD 25 BB 6 200 EE 70 CC 7 </tbody>
  13. A

    Comparison Failing

    I feel this should be a very easy solution, but I am finding myself struggling. For p = 70 To 73 If tpgo = "<" Then pdd = format(ws_sbase.Cells(p, 2), "h:mm am/pm") If pdd >...
  14. D

    finding the date 3 months later, 6 months later, and 12 months later

    please help im trying to find the date 3 months later, 6 months later, etc.....taking into account working/business days only ....i already have a table set up for holidays
  15. L

    I want to Print the userform

    I am finding confused for printing the userform. Please help for creating excel VBA code for printing userforms.
  16. W

    Formula Help

    Hi I wondered if anyone could help me with what I am finding to be a rather tricky situation which I am sure someone can help with though! I have extracted information from another system (not excel) into excel and the cell states 8/2/19 and the data is 02/08/2019 17:00:00. I need to...
  17. JenniferMurphy

    Finding the last row in or length of a passed range

    Given pratings, a range, I can find the absolute range address, the number of rows and columns, and the number of the first row and column. ?pratings.address $D$5:$G$14 ?pratings.rows.count 10 ?pratings.columns.count 4 ?pratings.row 5 ?pratings.column 4 Are there expressions...
  18. A

    Finding the lowest value variable

    I have 5 variables in that stores row numbers, I need to find out which has the lowest value and then put that value into another variable is there a way to do this without creating a horrible nested IF ELSE .?
  19. R

    Finding averages inside a named 1-dimensional range

    I have a named range (rYvalues) which is a singe column. It can be of variable length (7 to 365). If I want to take an average of a continuous section of that 1-dimensional named range, say average positions 50 to 99, how might I be able to do that? I've been all the web on this one and...
  20. K

    Finding Averages Across Multiple Columns That Meet Certain Criteria

    Hi, I want to be able to work out averages from a spreadsheet like below, across multiple columns. So for example, all of the averages from KWB1** to get a value f 2 returned, and then KWB2** to get what would be 7 in this example. Is there a way of just doing that in one formula? <tbody>...

Some videos you may like

This Week's Hot Topics