|
-
May 20th, 2003, 11:51 AM
#1
Thread Starter
New Member
if statement
I am new to this and would appreciate some help.
Say range c30 on sheet 1 value = 10
range b1 on sheet 1 value = 10
range c45 on sheet 1 value = 10000
I am trying to write the following statement
if Sheets("sheet1").range("c30").value = Sheets("sheet1").range("c30").value then
sheets("data").range("b9").value = sheets("sheet1").range("c45").value
else sheets("data").range("b9").value = 0
end if
It is not working. please help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|