This link should give you a clear example of what you need to do to make it work.
https://groups.google.com/forum/#!to...el/UeAYuh8LAN4
This link should give you a clear example of what you need to do to make it work.
https://groups.google.com/forum/#!to...el/UeAYuh8LAN4
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Bookmarks