.itemdn.value.offset

  1. marreco

    merge duplicate rows

    Hi Atry adapt a code, but din't work. Before Nº da NFe Série Data Emissão BASE ICMS ST CST Código do Produto 2805151 3 43643 110,78 210 101173 2805153 3 43643 100,44 510 100092 2805155 3 43643 1028,35 210 106447 2805157 3 43643 50,67 570 402850 2805159 3 43643 100,44 510 100092 2805161 3 43643...
  2. R

    Cannot delete duplicate row

    Hi, Please help on the following code supposed to delete rows with duplicate values in P column and keep the first instance after combining the values in the 8th and 10th columns, but I get the 1004 Delete method of Range class failed error on the EntireRow. Sub MG02Sep59() Dim Rng As Range...
  3. P

    VBA code blocked

    Hi all, i have the below code, which i was working for many years, but it block in a sheet on the point with blue letters. I would much appreciated if you could help me so that to run the code. The message which appears is follow: Run-time error '13': Type mismatch Thanks in advance Dim...

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