| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie question: clear contents in first column of copy-pasted row(s)
I need to code worksheet so that it will clear contents of column A in rows
being pasted/inserted into worksheet. Copied from location either above or below the insert location. Affecting only inserted rows. Hope this makes sense. Any help would be greatly appreciated. Thanks, -Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Newbie question: clear contents in first column of copy-pasted row(s)
Hi Brian,
See http://www.mvps.org/dmcritchie/excel...w.htm#insrtrow Selection.Offset(1).Resize(vRows).EntireRow. _ SpecialCells(xlConstants).ClearContents --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BN" wrote in message ... I need to code worksheet so that it will clear contents of column A in rows being pasted/inserted into worksheet. Copied from location either above or below the insert location. Affecting only inserted rows. Hope this makes sense. Any help would be greatly appreciated. Thanks, -Brian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Newbie question: clear contents in first column of copy-pasted row(s)
Thanks David for quick response to my question.
-Brian "David McRitchie" wrote in message ... Hi Brian, See http://www.mvps.org/dmcritchie/excel...w.htm#insrtrow Selection.Offset(1).Resize(vRows).EntireRow. _ SpecialCells(xlConstants).ClearContents --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BN" wrote in message ... I need to code worksheet so that it will clear contents of column A in rows being pasted/inserted into worksheet. Copied from location either above or below the insert location. Affecting only inserted rows. Hope this makes sense. Any help would be greatly appreciated. Thanks, -Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie question - column letter displayed instead of number | Excel Worksheet Functions | |||
| How to copy an Excel worksheet with formulas and clear contents. | Excel Discussion (Misc queries) | |||
| how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
| Newbie Question Column Adding Please Help | New Users to Excel | |||
| Newbie Post - Clear All Button | Excel Programming | |||
Linear Mode
