Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HY ALL !
My big problem is the next : I work in a whole worksheet ,[ from cell 91 to cell 65536 ] ; I have need a macro which to ClearContents of Range ,,C91:BB91,, if the value of cell BD91 < = 32 ; then next row , the same problem : if BD92 < = 32 , then , to delete ,,the Range" : ,,C92:BB92,, ; then , next row , and so on , from Row 91 to Row 65536 . Please very much to help me ! The macro can look like this [ I write this for pattern ] , but how can I modify it ? Sub Macrocomanda3() Dim Row As Integer, Col As Integer For Col = 1 To 4 For Row = 1 To 10 If ActiveSheet.Cells(Row, Col) = 1 Then ActiveSheet.Cells(Row, Col).ClearContents Next Row Next Col End Sub RESPECTFULLY TO ALL ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX useing Dynamic Range | Excel Worksheet Functions | |||
Return while useing CONCATENATE | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Email from Excel useing FollowHyperLink | Excel Programming | |||
useing arrows to move | Excel Discussion (Misc queries) |