Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim s3 As String
- Dim rng As Range
- Set SourceFile = Application.Workbooks.Open("c:financeinv.xls")
- Set SourceSheet = SourceFile.Worksheets(Source)
- s3 = SourceSheet.Range("A3").Value
- rng = SourceSheet.Range("A3:A30")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement