| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
not completeing mission
Worksheets("Data").Activate
Range("b4:m4").Select Selection.ClearContents Range("b4").Select Worksheets("MailE").Activate Range("b4:m4").Select Selection.ClearContents Range("b4").Select ' don't need this right' This is from a userform option button. Problem when clicked it clears contents and leaves row blocked until you close userform. I am missing something. Thanks to all the community All Of you are a great asset |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not completeing mission
This clears the cells without moving the cuusor, so the
row won't be "blocked". Sub ClrCntns() Worksheets("Data").Activate Range("b4:m4")..ClearContents Worksheets("MailE").Activate Range("b4:m4").ClearContents End Sub "Curt" wrote: Worksheets("Data").Activate Range("b4:m4").Select Selection.ClearContents Range("b4").Select Worksheets("MailE").Activate Range("b4:m4").Select Selection.ClearContents Range("b4").Select ' don't need this right' This is from a userform option button. Problem when clicked it clears contents and leaves row blocked until you close userform. I am missing something. Thanks to all the community All Of you are a great asset |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mission Impossible? | Excel Discussion (Misc queries) | |||
| Pivot table column creation: Mission Impossible ? | Excel Discussion (Misc queries) | |||
| EXCEL MISSION IMPOSSIBLE ? | Excel Discussion (Misc queries) | |||
| PIVOT TABLE + HYPELINK: Mission Impossible ? | Links and Linking in Excel | |||
| Mission Impossible | Excel Programming | |||
Linear Mode
