Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm a beginner VB and I'm trying to modify this code so that it would subtract column H against column F and put the resutl in column K...it should do that until there is a blank space in column D. I can't seemed to get it working...it only does H2-F2 and not for all the rows...any idea?? Row = 1 With Sheets("Data") Range("K2").Select Do While .Range("D" & Row) < "" ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-5]" selection.NumberFormat = "dd h:mm:ss" Row = Row + 1 Loop End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify code | Excel Discussion (Misc queries) | |||
Modify Code | Excel Worksheet Functions | |||
Modify existing code to dynamic code | Excel Programming | |||
almost there ... code modify help | Excel Programming | |||
Modify code in UDF | Excel Programming |