Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page how to copy different text from word into excel on consecutive rows how to copy different text from word into excel on consecutive rows
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2017, 10:06 AM
gmayor's Avatar
gmayor gmayor is offline how to copy different text from word into excel on consecutive rows Windows 10 how to copy different text from word into excel on consecutive rows Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Add
Code:
xlSheet.Cells(xlsNextRow, 2).Font.Bold = True
immediately before 'Else' i.e.
Code:
    xlSheet.Cells(xlsNextRow, 2) = Selection.Text
        xlSheet.Cells(xlsNextRow, 2).Font.Bold = True
    Else
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 05-08-2017, 12:09 PM
mihnea96 mihnea96 is offline how to copy different text from word into excel on consecutive rows Windows 7 32bit how to copy different text from word into excel on consecutive rows Office 2010 32bit
Novice
how to copy different text from word into excel on consecutive rows 		 
Join Date: Apr 2017
Posts: 26
mihnea96 is on a distinguished road
Default
It works great! Thank you very much!
Reply With Quote
Reply

Tags
word to excel text

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy different text from word into excel on consecutive rows Excel VBA macro to copy specific rows and delete it pourmalla Excel Programming 2 04-02-2017 12:09 AM
Counting Consecutive Periods In Rows Using Numbers Yaaseen23 Excel 18 03-24-2017 11:15 AM
Copy Underline text from Word and Paste into excel rfaris Excel Programming 7 10-05-2015 05:56 AM
how to copy different text from word into excel on consecutive rows Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word? Joey Cheung Word Tables 1 08-12-2014 05:15 PM
how to copy different text from word into excel on consecutive rows Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 AM.

Contact Us - Privacy Statement - Top

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