Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub joanne()
For i = 15 To Cells(Rows.Count, "C").End(xlUp).Row If Cells(i, "C").Value 0 Then Cells(i, "D").Value = 65 End If Next End Sub Put this in a standard module -- Gary''s Student - gsnu20076b "Joanne" wrote: Using MSOffice2003 On my spreadsheet, I want to do this: If C15.value 0 then D15.value = 65 Then I want to copy this down these two rows. Where do I put this code, and am I using proper Excel VBA syntax? Thanks for your help. Joanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
How to assign same code inside Option button code space ?? | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |