active cell column

  1. W

    Add a value to a current cells value

    Hi there, I have a worksheet that pulls through hourly sales for the previous trading week. It stores these values for Monday C4:C25, Tuesday F4:F25 and so on through to Sunday. For clarity, lets call that Table 1. I want to be able to compute an average of sales taken within a certain...
  2. littlefish

    Macro Tweak - Selecting Active Cell

    Good morning. I have a spreadsheet with two tabs. One contains data that gets manually updated. For each row updated, I run a macro which copies the unique code ID (column F) to a second tab. The macro runs fine as-is, except in the cases where there are blank columns of data for any given row...
  3. P

    Indirect Funtion to retrieve last cell with Data

    Hi Thanks to the help I was able to built a code that retreives the worksheet name in column 5, now I was looking -but I din't find - a way to have the Indirect funtion to point the sheet name and in addition to retrieve the last cell with data in a specific column (that changes based on the...
  4. A

    Cell Offset using Worksheet_SelectionChange subclass

    I have a scanner that scans and tabs across to next column. Once it gets to a certain column (i.e. column D) I need it to return 1 row down, back to column B. I figured the best way to handle this would be the SelectionChange excel object in VB. However, I just attempted to just use 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