Give me chocolate and no one gets hurt!
 Posted: Tue Aug 08, 2006 1:02 am Post subject: |
 |
| um, why do you need to move to the cell to paste the info?
Range(varTarget).Select ActiveSheet.Paste can be replaced with: Range(varTarget).Paste No need to actually select the cell you want to paste to when you are using VBA. also, if you want to paste something a certain distance from a given cell, the command you probably want to use is the offset command and/or the cells command. It's really late here and i'm not sure what the objective is. I'll check back in the morning or feel free to prill me. _________________ Open: Ricky - 128 laff, HW50 RB50 no Trap, loves pink magnets Princess Ladybug Bageltoes - 42 laff HW50 Miss Bananswirl - 122, laff HW50, RB50 (seems I stole her just yesterday) See Green Dog - 30 laff HW50 (yes, that is her name) Princess Izzy - 83 laff HW50 RB50 (nice doodle) Test: Pig - 107 laff (a Bear from before Pigs won) Paradox - 110 laff (Yes, a Brown Monkey, are you happy now?) Married to: McEngineer Life is short, eat dessert first! |
|
   |
