| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all cells in range matching certain values
I have a range selected dynamically using this: Range(Cells(4, 3),
Cells(4, 3).End(xlDown)).Select Within the range is a list of strings.However some of the cells contain the value "0". I would like to be able to sort through the selected range and delete the value 0 from the cells containing this value so that I end up with just a blank, clear cell in its place. The reason for this is that the range eventually gets sorted for non-empty cells so I need the 0 removed if present. How would I go about this using VBA? Regards, Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete all cells in range matching certain values
For Each cell In Range(Cells(4, 3),Cells(4, 3).End(xlDown))
If Cell.Value = 0 Then cell.Value ="" Next cell -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tommy" wrote in message ups.com... I have a range selected dynamically using this: Range(Cells(4, 3), Cells(4, 3).End(xlDown)).Select Within the range is a list of strings.However some of the cells contain the value "0". I would like to be able to sort through the selected range and delete the value 0 from the cells containing this value so that I end up with just a blank, clear cell in its place. The reason for this is that the range eventually gets sorted for non-empty cells so I need the 0 removed if present. How would I go about this using VBA? Regards, Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete all cells in range matching certain values
On 13 Aug, 15:45, "Bob Phillips" wrote:
For Each cell In Range(Cells(4, 3),Cells(4, 3).End(xlDown)) If Cell.Value = 0 Then cell.Value ="" Next cell -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tommy" wrote in message ups.com... I have a range selected dynamically using this: Range(Cells(4, 3), Cells(4, 3).End(xlDown)).Select Within the range is a list of strings.However some of the cells contain the value "0". I would like to be able to sort through the selected range and delete the value 0 from the cells containing this value so that I end up with just a blank, clear cell in its place. The reason for this is that the range eventually gets sorted for non-empty cells so I need the 0 removed if present. How would I go about this using VBA? Regards, Tom- Hide quoted text - - Show quoted text - gracias |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Matching cells across columns, and returning equal values | Excel Discussion (Misc queries) | |||
| Lookup 3 matching values of which one is a range and return a sum | Excel Worksheet Functions | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Matching cells & returning values | Excel Programming | |||
| Delete Rows if Certain Values are listed in a Range Name | Excel Programming | |||
![Tommy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
