named cells

  1. C

    Named ranges from multiple sections of cells copy paste not working

    I named 4 different sections of cells as a range name, specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split" I wanted to copy paste into same range on sheet 1 and named it "splittgt" It gets all the way to paste then gives me this error. "This action wont work on multiple...
    • Caveman1964
    • Thread
    • copy & past table copy & paste copy & paste array copy & paste named ranges macro - copy/paste named cells split
    • Replies: 6
    • Forum: Excel Questions
  2. M

    Return a List of Cell Names Based on Value

    Hi Folks, I am assessing the values of several thousand data sheets. So far, I am running a macro to conditionally highlight cells of specific values, then writing down the table location. I am trying to expedite the process by getting Excel to list the cell names for me. I named each cell...
  3. J

    Renaming cells across entire sheet

    Hi All, I have a workbook with a lot of hardcoded formulas, many referring to different sheets. In order to clarify the formulas, I retroactively changed some of the inputs to named cells. The formulas, however, still appear as numbered cell references, and not named cells - is there a...
  4. B

    Lock Cell range(Defined Names) but allow editing of cell content?

    Hey gang, I have developed an excel template that my company can use to calculate and format their KPI stats. My company desired that the presentation include a header and footer that were Word specific and outputting to PDF. So originally this process involved copying the cells from the Excel...
  5. A

    VBA to hide named cell areas in excel

    Hi All, Please help with a VBA to hide / unhide rows based on named cell areas. I have a dropdown button with the following options: New > 250 but <750 New >750 Existing >250 but <750 Existing >750 Ending I have the following named areas: Pricing : rows 36-57 Customer : rows 62-65 Payment ...
  6. Z

    Name cell and use in formula (VBA Excel 2007)

    Hello, I'm trying to figure out the following: I have a cell in Excel sheet that I define with a name. Next I want to use that specific cell in a VBA calculation, using that name. How can I write this code in VBA? as an example: calculate an average of a group of cells, then multiply that...
  7. K

    Pasting Worksheet with Named Cells into New Workbook

    OS: Win XP Office: 2007 I am having trouble copying and pasting a worksheet with named cells from one workbook to another. The named cells in the original workbook are scoped to the worksheet. The destination workbook includes several worksheets, 4 different summary sheets and a large number...

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