Posted to microsoft.public.excel.programming

external usenet poster

Posts: 10

Data Validation and Macros

I have a spreadsheet that tracks inspection dates and ratings. I have macro
that moves the current dates and ratings to the prior year at the end of the
inspection season. The ratings are picked from a validation list, but the
validation is lost. Is there a way to recreate the validation within the
macro?

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
custom data validation on cells with data validation values	AKrobbins	Excel Worksheet Functions	2	June 21st 11 04:20 PM
Excel 2007-programming macros that apply to data validation	Derek Megyesi	New Users to Excel	1	January 31st 10 10:11 PM
Data Validation & Macros	Michael Link	Excel Discussion (Misc queries)	2	March 9th 05 05:32 PM
Validation/Macros	Tom Ogilvy	Excel Programming	1	January 15th 04 04:21 PM
Validation/Macros	Ron de Bruin	Excel Programming	0	January 15th 04 04:13 PM

All times are GMT +1. The time now is 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us