Scott
12/19/2006 9:54:00 PM
Hi,
I am generating Validation strings in my code, and then trying to paste
the same strings onto several different lines.
I can put the validation strings into any data type necessary in my
code, but the only way I know to Paste Special -> Validation is to do
the following:
1) Put the validation strings into the spreadsheet somewhere.
2) Copy the section.
3) Paste Special -> Validation
Is there a way to either (A) go directly to step 3 from the String
array I have in my subroutine, or (B) bypass the need to paste in step
1, going right to copying?
Hopefully it's clear.
Scott