finding

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

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...

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.

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

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

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

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!

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...

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...

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...

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...

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>

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 >...

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

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

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...

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...

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 .?

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...

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>...