lr3

  1. Nelson78

    VBA, Arrais and Dict: combine duplicate rows and sum the values

    Hello everybody. I have a table in the following range: Worksheets(1).Range("A2:R" & lr2 + lr3 - 3) Having column A as a reference point (it is a list of cities), if the same city is repeated, I've to sum all the value in column in order to produce only a row for any city. Then overwrite...
  2. A

    Slow opening of Excel file

    Hello, I've a file Excel with a pivot table and some macro. When I open this file, I need to wait some minutes (I can see the logo of Excel and the writing "Calculation ongoing (8 thread)"). Can be the presence of this macro? It uses to delete some rows. Dim LR3 As Long, i3 As Long With...
  3. L

    Do I need .SELECT here? Columns not filling as expected.

    Here's a short section of my code. With comp .Range("A1").PasteSpecial xlPasteValues .Rows("1:3").Delete .Columns("B:B").Delete .Columns("A:B").RemoveDuplicates Columns:=Array(1, 2), Header:=xlNo LR2 = comp.Cells(Rows.Count, 1).End(xlUp).Row .Range("A1:B" & LR2).Copy End...
  4. B

    Vba else if

    Hi guys, I have the following VBA script that doesn't quite work for some reason. Basically I want the script to place the cursor at the 1st free cell of either of my 3 columns depending on which columns have more rows of data. Is there any obvious error in my code? See what happens is if lr1...

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