| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change cellvalue based on value in adjacent cell
In my account data i have amount in column h and Debit, Credit (DR/
CR) in next column. To modify the values in column h the code is ........ For Each c In Range("H2:h" & t) If c.Offset(0, 1) = "DR" Then c.Value = c Else c.Value = -c End If Next ........ This part of macro takes abnormally high time. Please suggest any alternative to make this faster. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i update filter in a pivottable based on a cellvalue? | Excel Discussion (Misc queries) | |||
| How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
| Excel automation issue---enter date into cell based on other cellvalue | Excel Programming | |||
| Different validation list based on cellvalue on the left | Excel Worksheet Functions | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
Threaded Mode
