Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |