novba

  1. J

    Dynamic print area, multiple sheets with Office Script button

    Hello, I am hoping I can accomplish the following. setPrintArea(printArea) Set the print area to the dynamic array on the active sheet. Use same cell X2# on all printing sheets. There are twelve. Twelve buttons, one Script. Has anyone done this before? I read about dynamic print ranges, but...
  2. J

    highlight cell based on coordinates in another sheet

    Hello, in my workbook i have 3 sheets, 2 contain data (Sheet 1 and Sheet 2) and another references specific cells on those 2 data sheets. the reference sheet looks like this is there a way (prefereably without VBA) that i can highlight the cells in the data sheets (sheet 1 and 2) that are...
  3. R

    An Array to track data into a new tab

    Hi guys, I had a formula, that would copy data from a cell to another sheet, based on a value in another cell within the Row. To do this, I had a count formula on the end, that added 1 each time the trigger value was met. But the first cell was its own formua as i needed the option of a 0...

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