range activecell

  1. E

    How to specify multiple separate cells for copy in VBA

    Hi, I have this code originally given to me by ZOT in 2020 and since modified. But now instead of the resize I want to copy multiple separate cells all on the same row dependent on the (r, C) method used in "FirstCell" - somethng like the range I tried to make below but fails. This must be...
  2. tzcoding

    VBA CODE that checks if two cells are matched

    I need help getting this VBA code below to work automatically across multiple cells. I was using this formula before =IF(S6=Q6, "MATCH", "NOT MATCH") and just copying it down to the next cell below, but that's not efficient with a larger data set. Help Need: I need the VBA code to look at a...
  3. A

    Dynamic Formula Based on latest column added (Budget Vs actual)

    Hello experts, I need your help to know what formula should I apply to get dynamic results. In the attached spreadsheet I have sample data of my monthly report, where we have monthly actual column and remaining month forecast (M05 to M12). I also have monthly budget and monthly forecast...
  4. I

    How to select range from ActiveCell to cell 1058476 in the same column.

    Hello, I am trying by VBA code to sekect a range from the active cell to the very last cell in the same column (on row 1048576) regardless if it is empty or not. I have tried the code below without sucess. Range(ActiveCell, ActiveColumn & 1048576).Select Greatful for any suggestion. Ingemar

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