Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code...
I have written the following code however i get the error "Type
Mismatch" and the code "C1" Has anybody got any suggestions as to how i can resolve this problem? Private Sub Worksheet_Change(ByVal Target As Range) Call inputs("C1") Call inputs("C2") Call inputs("C3") Call inputs("C4") Call inputs("C5") Call inputs("C6") Call inputs("C7") Call inputs("C8") Call inputs("C9") Call inputs("C10") Call inputs("C11") Call inputs("C12") Call inputs("C13") Call inputs("C14") Call inputs("C15") Call inputs("C16") Call inputs("C17") Call inputs("C18") Call inputs("C19") Call inputs("C20") Call inputs("C21") Call inputs("C22") Call inputs("C23") Call inputs("C24") Call inputs("C25") Call inputs("C26") Call inputs("C27") Call inputs("C28") Call inputs("C29") Call inputs("C30") End Sub Private Sub inputs(rangeref As Range) If rangeref.Value = "yes" Then rangeref.EntireRow.Delete End Sub Regards, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |