Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Improve code
There must be a better/quicker way of putting an R in
column L if column B has a 1 in it, at the moment I have the following: Sub Macro1() Dim cell As Range For Each cell In Range("B2:B" & Range("B65536").End (xlUp).Row) If cell.Value = 1 Then cell.Offset(0, 10).Value = "R" End If Next cell End Sub The sheet may have several thousand rows. TIA. Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How can improve this formula? | Excel Worksheet Functions | |||
How to optimize and improve that code ? | Excel Programming | |||
Improve ADO code, Export Excel to Access | Excel Programming | |||
How to improve this code? | Excel Programming |