Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The below code works fine on the 5 computers I've installed it on.
However, one computer is not liking the "kill" command, I've stepped through and it kicks out of the sub once it hits the "Kill cell" line. Any idea why? Dim rng As Range, cell As Range Set rng = Range(Cells(1, 3), Cells(1, 3).End(xlDown)) For Each cell In rng If Dir(cell) < "" Then Kill cell End If Next TIA, Mike *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
clicking on "My Computer" does not find my Template just created | Excel Discussion (Misc queries) | |||
kill "enable macros" message | Excel Discussion (Misc queries) | |||
"Hyperlinks can be harmfull to your computer and data...." how to shut this off | Excel Discussion (Misc queries) | |||
a button to open up "My Computer" on an excel sheet | Excel Programming |