Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel Data Validation - copy command overwrites

I have several columns within a worksheet that have data validations.
When a user copy/paste or cut/paste data into the cell. The dat
validation is lost.

I would like to allow copy/paste or cut/paste into the column an
maintain data validation. Can this be done and if so how?

thank

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Excel Data Validation - copy command overwrites

Hi
AFAIK this can't be done

--
Regards
Frank Kabel
Frankfurt, Germany


I have several columns within a worksheet that have data validations.
When a user copy/paste or cut/paste data into the cell. The data
validation is lost.

I would like to allow copy/paste or cut/paste into the column and
maintain data validation. Can this be done and if so how?

thanks


---
Message posted from http://www.ExcelForum.com/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 ! Christoffer Bloch Andersen Excel Worksheet Functions 1 March 18th 09 01:22 PM
Macro to combine worksheets data - overwrites existing [email protected] Excel Discussion (Misc queries) 5 May 1st 08 08:54 PM
problem data validation and copy/paste Theo Excel Worksheet Functions 2 January 13th 08 08:30 PM
Bloomberg overwrites data-need to save stream of data in a new she Melanie Excel Worksheet Functions 2 December 27th 07 05:42 PM
how do i enter data using formula and the Copy command For exa. 5494 New Users to Excel 0 January 28th 05 05:55 AM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"