D
Dan B
Hi, please help...
1. Is there anyway to have a range of cells filled in with a color for on
screen purposes, but not have that color print when printing the worksheet?
2. How can I lock only certain ranges of cells, not the entire worksheet,
to prevent editing of those ranges only?
3. I am using the following function: =VLOOKUP(A18,Codes!$A$7:$C$38,2)
Is there anyway to copy this to a range of cells without having a #N/A show
up in the rows that do not have a value in the A column. Basically I want
to have the formula there, but have the cells be blank until a value is
entered into the A column.
I hope that makes sense.
Thanks for the help,
Dan
1. Is there anyway to have a range of cells filled in with a color for on
screen purposes, but not have that color print when printing the worksheet?
2. How can I lock only certain ranges of cells, not the entire worksheet,
to prevent editing of those ranges only?
3. I am using the following function: =VLOOKUP(A18,Codes!$A$7:$C$38,2)
Is there anyway to copy this to a range of cells without having a #N/A show
up in the rows that do not have a value in the A column. Basically I want
to have the formula there, but have the cells be blank until a value is
entered into the A column.
I hope that makes sense.
Thanks for the help,
Dan