Fill blank cell with value from adjacent cell

kevinbradley57 · #1 04-16-2018, 03:30 PM

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.

p45cal · #2 04-17-2018, 01:09 AM

Code:

Sub blah()
With Intersect(Range("E:E"), ActiveSheet.UsedRange)
  .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=RC[1]"
  .Value = .Value
End With
End Sub

kevinbradley57 · #3 04-17-2018, 08:40 AM

Perfect -- thank you!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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