row.value

  1. L

    for each item in 1 sheet search for it in another and execute code

    Hi, again I’m new to macro writing so please be patient with me. Thank you!! What I have is: I have sheet 2 as my active sheet Sheet 1 as my source sheet What I need to do is: Read column A in sheet 2 and for every item in column A I want to look for it in sheet 1 (source sheet) column A and...
  2. L

    Move data from on column to another

    Hello, I am new to macros and this may be a simple question, hope you can help. PLEASE!! Thanks! I'm trying to search for any string with a ":" from column M and move it to column D but start at a specific row based on a search i have. For example: This finds kis emr and returns the row...
  3. S

    IF Statement Not Working - Need 2nd Pair of Eyes

    I cannot figure out why my IF statement won't populate the matches in the highlighted cells from the image above. Any thoughts? Do Until Range("AQ" & row).Formula = "" match1 = "" match2 = "" match3 = "" code1 = Range("AQ" & row).Value code2 = Range("AR" & row).Value code3 = Range("AS" &...
  4. S

    RANGE .VALUE & .FORMULAR1C1 Will Not Accept - 1004 'Range of Object Error'

    Good Morning Experts, I have used the following in many of the macros I have built, and for some reason, this particular procedure doesn't like my code and I cannot figure out why. This time I've used a different looping method and added multiple variables. I've highlighted the errors I...
  5. S

    CODE DOES NOT RUN - No Errors, just doesn't run

    Hi Guys, I worked on a code over the weekend on my computer at home, which has Excel 2016. This code worked over the weekend on my computer at home, but I haven't been able to get it to run on my work computer (Excel 2013). I'm not sure the differences in Excel builds are the problem... The...
  6. S

    IF "MATCH" is FOUND is myrange THEN "MATCH" - Help needed please

    I'm trying to write in a procedure that will: IF AL2, AM2, AN2 = "MATCH" THEN range("AO").value = "MATCHES" more or less, if the word "MATCH" is found in any of the cells AL2, AM2, or AN2 then I need AO2 to return "MATCHES". If not, then "NO MATCH" then loop it. THANKS GENTS Sub...
  7. sharky12345

    Problem updating cell values using Listbox ListIndex

    I'm trying to update a worksheet using the ListIndex of a Listbox, like this; Row = ListBox1.ListIndex + 2 With Sheets("Contacts List") Range("A" & Row).Value = TextName.Value Range("B" & Row).Value = ComboType.Value Range("C" & Row).Value = TextRelationship.Value Range("D" & Row).Value =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top