rows.count.endxlup

  1. C

    Rows.Count).End(xlUp).Row

    Not sure where this is wrong , but... The below only puts new data on Row 35. If Row 35 has data, it will simply write over it. Where am I wrong? This is making me crazy! Currently there is data on Rows 2 and 3 and then nothing until 35. Row 1 is the header Row... Public Sub PDMRA_Copy() Dim...
  2. H

    Lookup Data in Sheet1 on Sheet2 or Sheet3 and Return Value

    Hi - How do I lookup an item on 2 lists with out the ws3 overriding the ws2 inputs? basically changing it so that if it cant find the item from ws1 in ws2, then look in ws3. This is the code I tried to modify to add ws3. thanks! With CreateObject("scripting.dictionary") .CompareMode = 1 For...
  3. H

    Vlookup Alternative

    Hi - I'm using the code below to lookup data in Ws2 and place it in Ws1. Currently if the value in Ws1 Column A isn't found in Ws2 Column E it will put a "N" in Column P. How do I tweak it so that it only changes the cells in Column P when there is a match between Ws1 Column P and Ws2 Column...
  4. B

    Split To Columns

    looking to Split Data in Column A into column b and column c. the below removes the text to the left of the coma. Thanks Sub SplitComma() Dim d As Range For Each d In Range("A2", Range("A" & Rows.Count).End(xlUp)) d.Value = Split(d.Value, ", ")(1) Next d End Sub
  5. L

    Sum of Offset Values

    Hi, I have this formula, but i would like to just have in "K" the sum of offset(0,3)+offset(0,4) is it possible on VBA or should i add up that on the sheet and just copy it? Rw = 11 With Sheets("Draft") For Each Cl In .Range("K7", .Range("K" & Rows.Count).End(xlUp)) If Cl.Value =...
  6. S

    VBA Dictionary mumps Code highlight both non matching columns

    https://www.mrexcel.com/forum/excel-questions/1054389-compare-two-column.html Based off of the thread above, how do I get the code to highlight both columns if they do not match. mumps code: Sub CompareLists() Application.ScreenUpdating = False Dim Rng As Range, RngList As Object...

Watch MrExcel Video

This Week's Hot Topics

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
Top