#1
|
|||
|
|||
Fill blank cell with value from adjacent cell
I need code that will fill any blank cell in Column E with the value of the cell in the same row of Column F.
|
#2
|
||||
|
||||
Code:
Sub blah() With Intersect(Range("E:E"), ActiveSheet.UsedRange) .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=RC[1]" .Value = .Value End With End Sub |
#3
|
|||
|
|||
Perfect -- thank you!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF adjacent cell empty Copy from Other Column | ChrisOK | Excel Programming | 8 | 03-08-2018 09:17 PM |
Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
Entering a number in a cell causes it to fill with the color of a nearby cell | Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
If id cell range is empty then should not allow to fill any other cell | ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |