Results 1 to 4 of 4

Picking Sheet(2) in this line of code

Threaded View

realniceguy5000 Picking Sheet(2) in this line... 05-05-2009, 03:27 PM
stanleydgromjr Re: Picking Sheet(2) in this... 05-05-2009, 04:24 PM
shg Re: Picking Sheet(2) in this... 05-05-2009, 04:34 PM
realniceguy5000 Re: Picking Sheet(2) in this... 05-06-2009, 07:54 AM
  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Picking Sheet(2) in this line of code

    Hi, This should be a simple one, But I can get it to work.

    Could someone advise me as to how I can change this line of code to pick sheet(2) as it is now it picks sheet(1) . and throws the formula off.

    In A nut shell the formula is looking at sheets(1) C3 When it needs to look at sheets(2) C3

    I always get messed up with the & and "" and !

    Thank You, Mike


    ActiveCell.FormulaR1C1 = "='" & wbResults.Name & "'!R3C3"
    Last edited by realniceguy5000; 05-06-2009 at 10:08 AM.

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