Referencing a cell on another worksheet in VBA

Hello,

I am trying to do an if statement in VBA. From Sheet3 A25 I want to check if the value of Sheet1 F362 > 0. I would then make Sheet3 A25 equal to some value. When you record a Macro and check the code it does more of a relative location type deal and I want to be specific about which cell. Any help would be greatly appriciated.

KPT

How about trying the code as below....

IF Sheets("sheet1").Range("F362") > 0 Then Sheets("sheet3").Range("A25") = (your own value)

You can reference a range on another sheet like this:

Function ReferenceARangeOnAnotherSheet() As Range
'I wrote Sheet 5 because it is simply easier to differentiate from the
'exclamation point than a numeral 1 would have been

Dim Rng As Range
Set Rng = Range("=Sheet5!$B$1")
Set ReferenceARangeOnAnotherSheet = Rng

End Function

In the immediate window, try:

Debug.Print ReferenceARangeOnAnotherSheet.Address