How to retrieve value from specific cell value?
 

Does anyone have any suggestions on how to retrieve value from specific cell
value with specific worksheet?
I would like to create a if-statement within macro,
If specific cell within specific worksheet = 1 then
process following code
End If
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to retrieve value from specific cell value?
 

hi
If Sheets("sheet1").Range("A1") = 1 Then
MsgBox "run code"
Else
MsgBox "skip code"
End If

regards
FSt1

"Eric" wrote:

Does anyone have any suggestions on how to retrieve value from specific cell
value with specific worksheet?
I would like to create a if-statement within macro,
If specific cell within specific worksheet = 1 then
process following code
End If
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric