addrow

  1. X

    Problems when i add new rows in table via userform. Formulas wont get taken over and cell formats are changing

    So i have this table here: DEFGHIJKL4#BewerbungslisteOrtDatumPortalStatusLetztes UpdateTage seit BewerbungKommentar51Roland Deeg GmbHKirchberg an der Jagst23.10.2023Bewerbung per HomepageAbsage22.11.202338Die Bewerbung ist 38 Tage her62JMS AG Jet Maintenance &...
  2. J

    VBA anchoring specific cell??

    Hi All, I'm still new to VBA but have since been experimenting with it for a piece of work I'm doing. I'm trying to add a row to the bottom of my table and have succeeded to an extent, however the formula it copies down when it adds the row becomes anchored using the "$" for some reason. The...
  3. D

    Macro to insert a row under my header row

    I have created a table. I tried to record a macro where cells are added under the header row because I want to add new data at the top of the table. When I hit run macro, it gives me a big red circle with a white x in it and the number 400 beside it. Help!
  4. S

    VBA Help Speed up Dupe Code

    Good afternoon, I have code below that copies duplicates to sheet2. The code works find but is slow. Does anyone have any other way or code that is faster? Thanks in advance! With over 100,000 rows it is slow! Sub Dupe() Sub Dupe() Dim sh1 As Worksheet Dim sh2 As Worksheet Set...

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