Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
I know this code below will clear the text in a row.
But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
hi
is iCurrentMergeStart the name? if so then.... ActiveWorkbook.Names("iCurrentMergeStart").Delete regards FSt1 "greg" wrote: I know this code below will clear the text in a row. But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
If you are right and iCurrentMergeStart is the name given to a named range,
then I would think (based on how the OP phrased his message) that he would be looking for this... Range("iCurrentMergeStart").ClearContents or, if iCurrentMergeStart is a variable containing the name, then this... Range(iCurrentMergeStart).ClearContents rather than a method to physically delete the name from the Names collection. But then again, you might be right as the question was not very clearly stated to me. Rick "FSt1" wrote in message ... hi is iCurrentMergeStart the name? if so then.... ActiveWorkbook.Names("iCurrentMergeStart").Delete regards FSt1 "greg" wrote: I know this code below will clear the text in a row. But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
hi
you may be right. but from his title "clear data AND Named cell", i assumed that was what it wanted. he is already clearing the data. and i did ask. is that the name? question not clearly stated Regards FSt1 "Rick Rothstein (MVP - VB)" wrote: If you are right and iCurrentMergeStart is the name given to a named range, then I would think (based on how the OP phrased his message) that he would be looking for this... Range("iCurrentMergeStart").ClearContents or, if iCurrentMergeStart is a variable containing the name, then this... Range(iCurrentMergeStart).ClearContents rather than a method to physically delete the name from the Names collection. But then again, you might be right as the question was not very clearly stated to me. Rick "FSt1" wrote in message ... hi is iCurrentMergeStart the name? if so then.... ActiveWorkbook.Names("iCurrentMergeStart").Delete regards FSt1 "greg" wrote: I know this code below will clear the text in a row. But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
Hello,
Thanks for the help. Yes, clear the data and named cell. I really don't want to delete the row. But clear the data. and also remove all the named cells. "FSt1" wrote in message ... hi you may be right. but from his title "clear data AND Named cell", i assumed that was what it wanted. he is already clearing the data. and i did ask. is that the name? question not clearly stated Regards FSt1 "Rick Rothstein (MVP - VB)" wrote: If you are right and iCurrentMergeStart is the name given to a named range, then I would think (based on how the OP phrased his message) that he would be looking for this... Range("iCurrentMergeStart").ClearContents or, if iCurrentMergeStart is a variable containing the name, then this... Range(iCurrentMergeStart).ClearContents rather than a method to physically delete the name from the Names collection. But then again, you might be right as the question was not very clearly stated to me. Rick "FSt1" wrote in message ... hi is iCurrentMergeStart the name? if so then.... ActiveWorkbook.Names("iCurrentMergeStart").Delete regards FSt1 "greg" wrote: I know this code below will clear the text in a row. But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data and named cell
Remove "all" the named cells on a single worksheet (the one whose row you
cleared) or throughout your entire workbook? Rick "greg" wrote in message ... Hello, Thanks for the help. Yes, clear the data and named cell. I really don't want to delete the row. But clear the data. and also remove all the named cells. "FSt1" wrote in message ... hi you may be right. but from his title "clear data AND Named cell", i assumed that was what it wanted. he is already clearing the data. and i did ask. is that the name? question not clearly stated Regards FSt1 "Rick Rothstein (MVP - VB)" wrote: If you are right and iCurrentMergeStart is the name given to a named range, then I would think (based on how the OP phrased his message) that he would be looking for this... Range("iCurrentMergeStart").ClearContents or, if iCurrentMergeStart is a variable containing the name, then this... Range(iCurrentMergeStart).ClearContents rather than a method to physically delete the name from the Names collection. But then again, you might be right as the question was not very clearly stated to me. Rick "FSt1" wrote in message ... hi is iCurrentMergeStart the name? if so then.... ActiveWorkbook.Names("iCurrentMergeStart").Delete regards FSt1 "greg" wrote: I know this code below will clear the text in a row. But it will not clear out the named cells. Is there a way to clear both? Rows(CStr(iCurrentMergeStart & ":" & iCurrentMergeStart)).ClearContents |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
Clear cell data using Combo Box | Excel Programming | |||
Clear Named Ranges | Excel Programming | |||
VBA Macro to Clear Named Cell Contents | Excel Programming |