Advertisement
Guest User

Untitled

a guest
Oct 20th, 2014
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. Dim s3 As String
  2. Dim rng As Range
  3.  
  4. Set SourceFile = Application.Workbooks.Open("c:financeinv.xls")
  5. Set SourceSheet = SourceFile.Worksheets(Source)
  6.  
  7. s3 = SourceSheet.Range("A3").Value
  8. rng = SourceSheet.Range("A3:A30")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement