Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula in a coloum
I have this code
UltimaRiga = Range("A65356").End(xlUp).Row For i = 3 To UltimaRiga Range("G" & i).Value = (Range("D" & i).Value - Range("I" & i).Value) Range("G" & i).NumberFormat = "0_ ;[Red]-0 " Next i but I think is better (faster) without loop, is it possible? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count a coloum if two conditions are met | Excel Worksheet Functions | |||
Delete coloum in VB | Excel Discussion (Misc queries) | |||
how to change coloum to row | Excel Worksheet Functions | |||
Regonise coloum A while adding up coloum B to give a result in C | Excel Discussion (Misc queries) | |||
Need to import data to a coloum not a row | Excel Discussion (Misc queries) |