-
Thanks MD & Bob. Just one other question here if I may, if I wanted to write to a different sheet can I use the following to set the target? "Set Target = Cells (ActiveSheet "Sheet Name".Columns(1).Find(what:=Event, lookat:=xlWhole).Row,1) if the format was the same?
Ted
Edit: Hey Zack, stop nodding off and delete this 2nd post please.
PS Yes I will go stand in the corner for the next 3 hours to rethink my misdemeanor!!
Last edited by Aussiebear; 12-21-2006 at 12:18 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules