Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2018, 03:30 PM
kevinbradley57 kevinbradley57 is offline Fill blank cell with value from adjacent cell Windows 7 64bit Fill blank cell with value from adjacent cell Office 2010 64bit
Advanced Beginner
Fill blank cell with value from adjacent cell
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-17-2018, 01:09 AM
p45cal's Avatar
p45cal p45cal is offline Fill blank cell with value from adjacent cell Windows 10 Fill blank cell with value from adjacent cell Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Code:
Sub blah()
With Intersect(Range("E:E"), ActiveSheet.UsedRange)
  .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=RC[1]"
  .Value = .Value
End With
End Sub
Reply With Quote
  #3  
Old 04-17-2018, 08:40 AM
kevinbradley57 kevinbradley57 is offline Fill blank cell with value from adjacent cell Windows 7 64bit Fill blank cell with value from adjacent cell Office 2010 64bit
Advanced Beginner
Fill blank cell with value from adjacent cell
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default

Perfect -- thank you!!
Reply With Quote
Reply

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
Fill blank cell with value from adjacent cell 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
Fill blank cell with value from adjacent cell 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:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft