LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count a coloum if two conditions are met Mr Fujisawa Excel Worksheet Functions 5 March 1st 10 02:17 PM
Delete coloum in VB haviv Excel Discussion (Misc queries) 3 September 12th 08 09:29 AM
how to change coloum to row sangeet Excel Worksheet Functions 5 June 4th 07 04:13 PM
Regonise coloum A while adding up coloum B to give a result in C B.H.JIG Excel Discussion (Misc queries) 3 May 3rd 07 01:25 PM
Need to import data to a coloum not a row Russ M. Excel Discussion (Misc queries) 1 November 22nd 05 08:40 PM


All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"