Retrieving data in a sheet without viewing it.

[trexanderson]

I would like to retrieve some data in a workbook using a macro without going to that sheet, is there a simple way to do this?

[Nimrod]

Here's a couple of methods for you

Public Sub GetValue()

CellValue = Sheets("Sheet1").Cells(1, 1).Value 'method one
MsgBox (CellValue)

CellValue = ActiveSheet.Cells(1, 1).Value 'method two
MsgBox (CellValue)

CellValue = Sheets("Sheet1").Range("A1").Value ' method 3
MsgBox (CellValue)

With Sheets("Sheet1").Cells(1, 1) ' method 4
    CellValue = .Value
End With
MsgBox (CellValue)

End Sub

I would suggest you use the VBE's help file and do a search on "How to Reference Cells and Ranges" if you care for many more examples

[ This Message was edited by: Nimrod on 2002-05-20 12:39 ]