mycheck

  1. C

    Loop over range and find data-type

    Hello everyone. I am having trouble finding the datatype in a cell, using a function. I have the sub to pass the argument into the function, the function itself is detecting the datatype (somehow it shows 0 as double, no decimals specified in the cell). But in the subroutine the myCheck value...
  2. M

    Copy last active cell in column and paste below with adding +1

    I need help! I have a macro that copies a specified row and pastes it one below the last active row. The columnX is basically a counter (starting from 1). I'm lookingfor a VBA command to add to my macro. The command will take the last active cellin column X, copy it and paste it one cell below...
  3. M

    Faster clearing contents

    I have the following question with this working VBA code and would appreciate some help (if at all possible) to make the code faster. Especially when clearing up to 50 cells. The shown VBA code is copying the last row of a table and inserts it below. Some cells are cleared from its contents. The...

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