View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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