Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-21-2021, 02:59 PM
rollis13's Avatar
rollis13 rollis13 is offline concat based on selected cell Windows 10 concat based on selected cell Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 143
rollis13 will become famous soon enough
Default

Well, your macro is doing what it's supposed to do. The only exception is that you have an extra "End If" (maybe only a typo).
Every time you click on a cell, if it's in column O and it isn't empty, then copy into the cell O9 the value of the cell of the row under the clicked cell.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
concat based on selected cell Paste value of selected cell to adjacent cell Marcia Excel Programming 3 08-26-2021 12:55 AM
Macro - Copying and Pasting selected slides (based on selected keywords/criteria) Hi erickhawe PowerPoint 0 08-16-2019 09:00 PM
concat based on selected cell Set Range based on selected rows. 14spar15 Excel Programming 8 11-19-2018 08:08 AM
concat based on selected cell Cell color based on cell value as compared to another cell va COgreywolf Excel 9 09-25-2018 12:28 PM
concat based on selected cell string concat stopped working? AlexanderJohnWilley Excel 6 09-27-2013 08:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:27 PM.


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