Results 1 to 20 of 33

Thread: Solved: Saving to various sections on the same sheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #14
    Site Admin VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,495
    Location
    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
  •