Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cesar Gonzalez   on Feb 04 In MS Office Category.

How to access many worksheets from one


  
Question Answered By: Kathleen Adams   on Feb 04

The use of range names and the Offset method can make it easier to refer to data
on other sheets programmatically:

ActiveWorkbook.Sheets("Widgets").Range("SalesData").Offset(1, 0).Value

Also, you can use the Vlookup function from VBA:

Data$ = Application.WorksheetFunction.VLookup("WhatToLookFor",
ThisWorkbook.Sheets("Widgets").Columns("A:D"), 2, False)

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to access many worksheets from one Or get search suggestion and latest updates.


Tagged: