rangec5

  1. A

    VBA - Same formula in the same column but different rows

    Since my last column is not always absolute I use the xlToRight command to get to the correct cell. I am trying to do the same step for row 5-11,14-20 and 23-29. Currently I have something like this: Range("C5").End(xlToRight).Formula = Range("C5") - Range("C5").End(xlToRight).Offset(0, -2)...
  2. X

    Copying data to another sheet with CurrentRegion.Rows and ignore formula columns

    Hi, I have a button to copy some cells to Sheet9. Please see the code below. This code copy data to next empty row in Sheet9. However, I have some math formula/function in column M, N and P in Sheet9. When I press the button, it's copying to the end after the last function row. How do I make it...

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