Posted to microsoft.public.excel.programming

CLR

external usenet poster

Posts: 1,998

Data Validation won't copy

Hi All......
XL2k, I record the following macro and it does fine, then when I try to run
it, it stalls on the Pastespecial line.......whut's up please?

Sub Macro2()
Range("E1").Select
Application.CutCopyMode = False
Selection.Copy
Range("E12").Select
Selection.PasteSpecial Paste:=xlDataValidation, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub

Vaya con Dios,
Chuck, CABGx3

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Copy Data Validation	CLR	Excel Programming	0	February 16th 10 08:20 PM
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
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:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us