Fill blank cell with value from adjacent cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Fill blank cell with value from adjacent cell

FAQ

Thread Tools

Display Modes

04-17-2018, 01:09 AM

p45cal

Windows 10 Fill blank cell with value from adjacent cell

Office 2010 32bit

Expert

Join Date: Apr 2014

Posts: 962

Code:

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 AM.