| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a "moving" range offset from Target
Hi Howard,
Am Thu, 22 Jan 2015 04:39:26 -0800 (PST) schrieb L. Howard: ' Target.Offset(, 1).Resize(tRowCount, tColumn).Select '.ClearContents try: Target.Offset(, 1).Resize(tRowCount - 1, 1).ClearContents Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "ElseIf c.Value = "X_Clear" Then" and "...Target.Cells.Count 1"don't work | Excel Programming | |||
| Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
| Clear if "#N/A" and Find End of Range, Fill Blanks | Excel Programming | |||
| Moving between "row" and "range" formats in VBA | Excel Programming | |||
| SQL "INSERT INTO" Does not Modify Definition of Target Range | Excel Programming | |||
Threaded Mode
