| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick question..:P (Row range)
Dim cell As Range For Each cell In Range("B:B") If Len(cell.Value) = 0 Then cell.Offset(0, 1).Interior.Pattern xlPatternGray8 Next How can I set this code so Excel doesn't apply this setting up to th 65 000th line? (max -- Turquoise_da ----------------------------------------------------------------------- Turquoise_dax's Profile: http://www.excelforum.com/member.php...fo&userid=3518 View this thread: http://www.excelforum.com/showthread.php?threadid=55466 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quick Question | Excel Discussion (Misc queries) | |||
| Quick question... | Excel Worksheet Functions | |||
| Another Quick Question | Excel Programming | |||
| Quick question - quick answer about assigning shortcut keys | Excel Programming | |||
| Very Quick Question | Excel Programming | |||
![Turquoise_dax[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
