Results 1 to 9 of 9

Choosing spreadsheet for paste

Threaded View

jomili Choosing spreadsheet for paste 02-02-2010, 04:55 PM
Paul Re: Choosing spreadsheet for... 02-02-2010, 05:02 PM
jomili Re: Choosing spreadsheet for... 02-02-2010, 05:04 PM
Paul Re: Choosing spreadsheet for... 02-02-2010, 05:20 PM
jomili Re: Choosing spreadsheet for... 02-02-2010, 05:53 PM
Paul Re: Choosing spreadsheet for... 02-02-2010, 06:06 PM
jomili Re: Choosing spreadsheet for... 02-02-2010, 06:15 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,054

    Choosing spreadsheet for paste

    I have a routine that copies from one worksheet ("Sheet2) and pastes into another ("Report") just fine:
    DstWkb.Worksheets("Sheet2").Range("A1:A144").EntireRow.Copy Destination:=DstWkb.Worksheets("Report").Range("A65536").End(xlUp).Offset(1, 0)
    However, I want to be able to paste to a variable worksheet. In other words, if my user chooses (from a dropdown) "Apple", I want to paste into "Fruit", and if he/she picks "Pig" I want to paste into "Animals". How do I write the variable into my little copy/paste routine?
    Last edited by Mordred; 08-30-2011 at 12:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1