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"
Bookmarks