-
MD, I have some code written but I need to firstly establish which event the new data applies too and then find the last row within that particular range.
What I need to know firstly, is... does the line " Set Tgt = Cells(ActiveSheet.Columns(10.Find(What:=Event, lookat:= xlWhole).Row,1) find the correct type of event?
and secondly can I then use the offset to find the last row within this section?
Ted
BTW my apologies to Bob for the wrong example posted.
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