changing cell range

  1. L

    Copy daily changing rows from a workbook paste to another workbook

    Hello, I’m trying to copy columns A:C down to row 52. ( Attached image source1 and 2) However the amount of rows I want to copy can change day to day. I want to create a macro that will copy in the data but since the amount of rows can change day to day I’m having issues. I’ve thought about...
    • LearningVBA9
    • Thread
    • changing cell range inbox method ranges input box interior color rgb vba workbooks
    • Replies: 1
    • Forum: Excel Questions
  2. A

    Count occurances of a specific cell value in a changing rang of cells

    Row 1 contains several hundred columns of data. I need to see if a specific character appears 4 times in a set of 28 columns ie. column 1 to 28, row 1 how many times does 'X' appear, Col 2 to 29 how many times does x appear, col 3 to 30 how many times does 'X' appear, etc etc The basic...

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