active cell range

  1. A

    Formula to show last activated cell in an array

    I have an array of cells B4:E4, I was wondering is there a formula or some code which will populate cell G4 with the last cell I have activated within the array. So once I click any of the cells in the array of B4:E4 cell G4 will change with some form of identifier, let’s say 1 for B4, 2 for C4...
  2. M

    How to fill a cell with the data from an active cell with a specific range

    Hello, I am trying to have an active cell within a range of cells populate into an empty cell at the top of the column range. I'd like to do this at the top of multiple column ranges. B1 will equal a selection from B2-B15 C1 will equal a selection from C2-C15 etc. I can do this using a...
  3. C

    Select cells between the active cell and another column on same row

    I'm not finding what I need. I have the following code. [CODE] Range("E1").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Select ActiveCell.FormulaR1C1 = "xxxxxx" Selection.AutoFill Destination:=Range("E58:AC58"), Type:=xlFillDefault [CODE] What I need to...

Watch MrExcel Video

This Week's Hot Topics

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
Top