Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents not clearing :(
Hi, I am using the following to clear a range of cells but it dosen't work please help With Workbooks("testcalcs_rev3.xls").Worksheets("initia l_information") trm = Workbooks("TestCalcs_rev3.xls").Names("Issue_term" ).RefersToRange.Value If trm = 20 Then Columns("C:L").Rows("70:89").ClearContents End If End With I can run the clearcontents by itself and it works fine but i need to be able to compare it to a value, hence the cell issue_term. if it equals 20 then i need to delete the cells listed if not it needs to just exit. thanks for your time joeH -- JoeH ------------------------------------------------------------------------ JoeH's Profile: http://www.excelforum.com/member.php...o&userid=14138 View this thread: http://www.excelforum.com/showthread...hreadid=263686 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents not clearing :(
Dim trm as Long
With Workbooks("testcalcs_rev3.xls"). _ Worksheets("initial_information") trm = Workbooks("TestCalcs_rev3.xls").Names( _ "Issue_term").RefersToRange.Value msgbox trm If trm = 20 Then .Columns("C:L").Rows("70:89").ClearContents End If End With Usually if something is within an IF construct and it doesn't occur, then the if construct test is not being passed. Use the msgbox to check the value of trm -- Regards, Tom Ogilvy "JoeH" wrote in message ... Hi, I am using the following to clear a range of cells but it dosen't work please help With Workbooks("testcalcs_rev3.xls").Worksheets("initia l_information") trm = Workbooks("TestCalcs_rev3.xls").Names("Issue_term" ).RefersToRange.Value If trm = 20 Then Columns("C:L").Rows("70:89").ClearContents End If End With I can run the clearcontents by itself and it works fine but i need to be able to compare it to a value, hence the cell issue_term. if it equals 20 then i need to delete the cells listed if not it needs to just exit. thanks for your time joeH -- JoeH ------------------------------------------------------------------------ JoeH's Profile: http://www.excelforum.com/member.php...o&userid=14138 View this thread: http://www.excelforum.com/showthread...hreadid=263686 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Clearcontents | Excel Programming | |||
ClearContents Not Clearing Query | Excel Programming | |||
Clearcontents | Excel Programming | |||
Clearcontents | Excel Programming |