stop cell ranges shift when copying functions.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I copy a function, and paste it into a different cell, the cell ranges
in the function shift to accomdate the data for the function. Sometimes, I
do not want that cell range to change. For instance, I am pasting a
NETWORKDAYS function in to a big group of cells. The range of holidays I
have declared are in a range of cells that is the arguement of the function
(NETWORKDAYS (start,stop,holidays). I want the start and stop arguement cell
ranges to shift, but keep the holiday arguement the same each time I paste
the function. Now, I have to paste the function where ever I want, then go
back and change the cell ranges in each line just for that arguement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function and a range 4
VBA set thick borders around non empty cells in range 0
Set non-continuous PrintArea via Function / Name 0
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Networkday & workday with array functions 1
Counta or daveragea functions 7
countif function doesnt work 2
Excel VBA 1

Back
Top