Reference cells

[Fire_Chief]

How do I reference a value in a cell that is in a difference worksheet.
I want to do it with VBA.

I know I can change worksheets get the value and come back but I think there is an easier way.

Thanks

 

[mikerickson]

you can use the sytax

myValue = Workbooks("WorkbookOther.xlsx").Sheets("Sheetname").Range("e46").Value

 

[Fire_Chief]

I had to change it a little but it worked fine
MYVALUE = Sheets("PAID or NOT").Range("AO24").Value

Thank You