Copying a validation

Hazel Dozer

New Member
Joined
Nov 21, 2005
Messages
1
I can copy the validated cell down a column BUT the cells change. eg

H1 the validated cell group is b15 to b25

when I copy down one cell to H2 it becomes b16 to b26

I want it to stay the same b15 to b25.

How do I do this??? :eek:
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,937
Welcome to the board.

The same $ reference rules apply to validation.

Try defining your list as $A$1:$A$10 in the validation before copying and pasting it.
 

Forum statistics

Threads
1,077,782
Messages
5,336,294
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top