Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1,998

Copy Data Validation

XL2k....I have Data Validation in several (not all) cells from A1:J1.

When I change the value, or insert one, in any cell down column A, I would
like all that Data Validation information to be copied from row 1 down to the
activerow, without changing any values in the activerow. I can do it by
hand, but dont' seem to be able to get there with code. Any help would be
apprecaited.

Vaya con Dios,
Chuck, CABGx3

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation - copy/paste	Ken Valenti	Excel Programming	3	June 18th 09 05:49 PM
Data Validation - copy paste !	Christoffer Bloch Andersen	Excel Worksheet Functions	1	March 18th 09 01:22 PM
data validation and copy/paste.......	MPR	Excel Programming	3	July 27th 06 03:02 PM
Copy/Paste over rides data validation	jk	Setting up and Configuration of Excel	1	July 23rd 06 03:39 AM
Excel2000: How to copy data validation using VBA	Arvi Laanemets	Excel Programming	1	July 13th 04 12:32 PM

All times are GMT +1. The time now is 10:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us