| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Simple VB Snippet Needed
Hey there,
Quick question as I am a bit rusty - I need a quick snippet to delete cell contents within the user selected area so that the cell returns to ISBLANK/nothing there status - IF the value of the cell = A specific value for example #N/A, or 1, etc... Best regards, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick Simple VB Snippet Needed
for each cell in selection
if cell.Value = 1 then cell.clearcontents end if Next -- Regards, Tom Ogilvy "Tim H" wrote in message ... Hey there, Quick question as I am a bit rusty - I need a quick snippet to delete cell contents within the user selected area so that the cell returns to ISBLANK/nothing there status - IF the value of the cell = A specific value for example #N/A, or 1, etc... Best regards, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick Simple VB Snippet Needed
Thanks Much!
"Tom Ogilvy" wrote: for each cell in selection if cell.Value = 1 then cell.clearcontents end if Next -- Regards, Tom Ogilvy "Tim H" wrote in message ... Hey there, Quick question as I am a bit rusty - I need a quick snippet to delete cell contents within the user selected area so that the cell returns to ISBLANK/nothing there status - IF the value of the cell = A specific value for example #N/A, or 1, etc... Best regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quick help needed... | Excel Worksheet Functions | |||
| Quick help with a simple function! | Excel Discussion (Misc queries) | |||
| quick code needed | Excel Programming | |||
| simple quick question | Excel Programming | |||
| Simple Question, need quick answer please | Excel Programming | |||
![Tim H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
