$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

uot;, "CV", "CX", "CY", _ >         "CZ", "DE", "DJ", "DK", "DM", "DO", "DZ", "EC", "EE", _ >         "EG", "EH", "ER", "ES", "ET"

$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

Hi, Thanks for the tip :) It is working without any error but there is another problem now. If i right the AT, or one of them it doesnt recognize... why it can be? Thanks On Mar 23, 3:48 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi xmux, > > This is totally invalid, since

$$Excel-Macros$$ Getting Run-time error 13 Type Mismatch by VBA Macro

Hi Everyone, I am just checking a Cell with If Selection.Cells(x, 8) <> _ "AD" Or "AE" Or "AF" Or "AG" Or "AI" Or "AL" Or "AM" Or "AN" Or "AO" Or "AQ" Or "AR" Or "AS" Or "AT" Or "AU" Or _ "AW" Or "AX" Or "AZ" Or "BA" Or "BB" Or "BD" Or "BE" Or "BF" Or "BG" Or "BH" Or "BI" Or "BJ" Or "BM" Or "BN"

$$Excel-Macros$$ Data Validation Problem with Copy/Paste

Hi all! I have a problem with Data Validation, when i copy and paste where Data validation is, than the data validation doesnt check anymore! So how can i check the entries after i copy paste?? thanks --~--~-~--~~~---~--~~